Home > IT Answers > Development > Alternative to using a cursor in SQL
SQL Server Ask the Experts
2,585 pts.
 Alternative to using a cursor in SQL
SQL, SQL performance
What is the best alternative to using a cursor in SQL if I am suffering from performance issues?

Software/Hardware used:
ASKED: July 30, 2008  7:22 PM
UPDATED: July 31, 2008  1:10 AM
RELATED QUESTIONS
Answer Wiki:
You will want to change your cursor to a record set. This will improve your performance greatly. If you can provide a sample of your cursor, more information can be provided.
Last Wiki Answer Submitted:  July 31, 2008  1:09 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.