Cursors Found in Slow Queries
Blitz Result: Cursors Found in Slow Queries
Row-by-row processing is a bad idea in SQL Server, but we’re not just about best practices here. This part of our SQL Server sp_Blitz® script checks the plan cache looking for resource-intensive queries that are using a cursor – these are where you want to start focusing on reducing CPU power requirements.
To Fix the Problem
Consider rewriting the query to do set-based operations instead of a cursor.