Optimize Cursors
- Avoid using SQL Server cursors whenever possible
- Always close SQL Server cursors when result sets are not needed
- Deallocate SQL Server cursors when the data structures comprising the cursors are not needed
- Reduce the number of records to process in the cursor
- Only use the required columns in the cursors
- Use READ ONLY cursors, whenever possible, instead of updatable cursors.
- Avoid using insensitive, static and keyset cursors, whenever possible.
- Use FAST_FORWARD cursors, whenever possible.
- Use FORWARD_ONLY cursors, if you need updatable cursors
From: http://sitestree.com/?p=4794
Categories:38
Tags:
Post Data:2010-03-10 01:20:46
Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a>
In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
<a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
