What are the disadvantages/limitation of the cursor?

Posted by Syedshakeer on 8/24/2009 | Category: Sql Server Interview questions | Views: 7288

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Cursor requires a network roundtrip each time it fetches a record, thus consume network resources.
While data processing, it issues locks on part of the table, or on the whole table.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Use of Bulk Copying ?

Next > : How to Get SQL Server Version ?

Comments or Responses

More Interview Questions by Syedshakeer

How to Get SQL Server Version ?
HashTable Class is present inside which of the following NameSpace?
Which of the following is Mutable?
What is the CAS ? .How to implement CAS ?
Difference between Static and ReadOnly?
Difference between XMLDoc and XMLReader?
What are the facilities available in .NET to deal with XML.
Which is the Best one for using String concatenation?

Latest Interview Questions

Should we need to dispose the object after use Explicitly or we need t ...
Which is the Light (Performance wise) Data control from the following?
What is the Max length of varchar variable in SQL Server?
What id the Max Length of nVarchar in SQL Server?
What is the Difference Between string and System.Text.StringBuilder?
What is the best state management variable to save the username for pa ...
Best Method to retrieve two values from Database (SQL Server)
Maximum Data that can be stored in a cookie?
More ...