Learn to use Where, Claire. Plus a conversion methodology, a test harness and more!  Read more...

Learn how to leave those Cursors and loops in the thrash, Nash... An article from longtime contributor and SQL expert, Barry Young.  Read more...

Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. This article shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them.  Read more...

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.   Read more...

A short tutorial on converting cursors to more conventional loops.  Read more...

In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples?   Read more...

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.  Read more...

This script opens a little cursor that will clean out connections to any DBs you specify.  Read more...