SQLServerCentral - Guest Columnist: Dave Ballantyne

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 | 4,918 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,371 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,489 reads