in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL (RSS)

Browse by Tags

  • Running Sums the sequel part x

    If you've been following the trillogy (Adams posts 1 , 2 Jamies post ) of attempts at getting a running sum out of TSQL you will appreciate that there are many ways to solve a problem. Following my previous post on partitions and aggregates I thought that might be an avenue. Well it is, and i've thrown...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Mar 12 2006
  • Increase the performance of updates by 1000

    Following on from my previous post on varchar(max) for which the consensus was that one shouldn't use varchar(max) everywhere, I have found this great function that allows you to update a varchar(max) column with great performance gain. The function is called Write and is used in an update statement...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 2 2006
  • Microsoft.com SQL Server architecture

    I was sent a link recently on the Microsoft.com SQL Aerver Architecture , this is really interesting and follows on from a interview I read last year with Jim Gray on channel9 that talked about terraserver using a white box solution rather than clustering. The key here is that scaling out a clustered...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Feb 14 2006
  • Indirect configuration files in SSIS

    Configuring packages based on configuration files is great, whats more you can have the location of configuration file obtain from an environment variable. One word of warning is that, if you change your configuration between indirect and direct the configuration file will be overwritten and your conifguration...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Feb 13 2006
  • Performance tuning with subqueries and parameters

    Patrick Wright has recently posted on a performance issue he was asked to look into. The issue in question involved an SP that was taking a huge amount of time, compared to what it should have been. This is one of those real life scenarios where its not a simple you need an index there are lots of factors...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jan 27 2006
  • Free training in advanced query performance (almost)

    There are a number of sites that offer free training or dedicated training however few offer the level of interaction you get at the UK Usergroup. Itzik Ben-Gan is holding an advanced query performance http://www.sqlserverfaq.com/?eid=62 . These events are very interactive sessions and speaking from...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Nov 21 2005
  • when is varchar(max) not a varchar(max)

    I was looking into a question raised at the lauanch about the best way to pass large sets of values to sql. Currently the person is restricted by the 8000 character limit for a varchar in SQL 2000. A number of options where mentioned including bulk inserting, xml, a user defined type and a varchar(max...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Nov 18 2005
  • Undocumented conversion of binary variable to a string

    There is an undocumented function in SQL Server for performing the conversion of a binary value into a string representation of the binary value i.e. 0x0233DAF to '0x0233DAF'. You can't just convert to a varchar because the varchar is just the characters representing the ascii values in the binary i...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Nov 12 2005
  • Job Schedules in SQL Server 2005

    For years now one aspect of SQL Server has bugged the hell out of me, but as time goes on some things you just accept. Job Schedules, I have never understood why you have to create a new schedule for every job you create. Well I was pleasently suprised when looking up the syntax for sp_add_jobschedule...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Nov 11 2005
  • Deleting/archiving data in SQL Server 2005

    A delete can now use TOP i.e. DELETE TOP (2000) FROM MyBigTableWHERE someCondition = true ORDER BY Dateolumn ASC Michael Campbell has blogged about removing data from a table in chunks http://sqladvice.com/blogs/repeatableread/archive/2005/09/20/12795.aspx . This can be simplified even further in SQL...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 10 2005
Page 4 of 5 (47 items) < Previous 1 2 3 4 5 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems