Avoid cursors
Avoid using cursors.It may result in Deadlocks.Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. During this kind of situation, SQL Server identifies the trouble and ends the deadlock by automatically choosing one process and aborting the other process, allowing the other process to continue.
Top 10 SQL server Performance tuning tips - 5
Monday 7 September 2009
Labels:
Cursors,
Performance,
Tips
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment