• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Using Cursors

Will there be any Performance issues while using Cursors in Sql 2005 in a Virtual SQL Server?
0
balakumar_m
Asked:
balakumar_m
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
cursors are generally to be avoided, whether you run in a Virtual or a Physical machine.
there is a nice technique to avoid cursors (using a "temp" tables). the only downside of that technique is that it might use more t-log activity (in tempdb), but that shall only play when doing very large resultsets to process.

and in case you can avoid the looping altogether, the better.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now