WHILE loop performance in SQL Server 2008 Your email has been sent ... I showed how you can convert some of your iterative queries (cursors) to set-based operations in order to enhance performance.