Use cursors wisely in your T-SQL Programming

T-SQL database developers and administrators with solid knowledge of the various cursor types and the syntax for declaring and using them will deepen their understanding of when and how to use cursors appropriately in this sample chapter from Inside Microsoft SQL Server 2005: T-SQL Programming . Closely examine multiple examples to learn why tuned set-based solutions outperform cursor alternatives for most types of problems. Then, examine the tools that allow you to identify the classes of problems that are exceptions—where currently SQL Server 2005 doesn't provide a better solution than using cursors. Ultimately, you will be able to discern confidently if a set-based solution is unlikely and if cursors are the most reasonable solution.

Title: Inside Microsoft SQL Server 2005: T-SQL Programming
ISBN: 0735621977
Published: May 2006
Authors: Itzik Ben-Gan (Solid Quality Learning), Dejan Sarka; Roger Wolter
Chapter: Chapter 3: Cursors
Published by Microsoft Press
Note: Microsoft book chapters are locked against printing, but you may download and save them to your PC for later reading.