Skip to main content
Performance Tuning SQL Server Cursors
Entry Date: Rate:
RSS Description:
If possible, avoid using SQL Server cursors. They generally use a lot of SQL Server resources and reduce the performance and scalability of your applications. If you need to perform row-by-row operations, try to find another method to perform the task.

T-SQL cursors are performance killers !!

This article first tell you to avoid them (and how to do that), and in case that you have to use cursors how to make it in the best possible way

A must read if you are querying against millions of rows...