Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Dave Ballantyne

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Optimizing a cursor based routine – Part 2

In the second part of his optimization series, Dave Ballantyne shows us how to add conditional logic to set based, more efficient T-SQL code.  Read more...
By Dave Ballantyne 2011/06/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,027 reads

Optimizing a cursor based routine – Part 1

Learn how you can remove a cursor and optimize a routine that loops through a series of data and performs various calculations in this short article from Dave Ballantyne.  Read more...
By Dave Ballantyne 2011/06/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,479 reads

Returning the Top X row for each group (SQL Spackle)

One of the most common T-SQL questions is on returning a ranked result set for each member of a group. Dave Ballentyne brings us a short tutorial on how you can do this in T-SQL.  Read more...
By Dave Ballantyne 2012/11/23 (first published: 2010/12/06) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 28,892 reads
   Items 1 to 3 of 3