⟩ Can you explain the disadvantages/limitation of the cursor?
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.
Question and Answer:
Home MS SQL Server Cursors
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is database replication? What are the different types of replication you can set up in SQL Server?
What are different types of BACKUPs available in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is the difference between DELETE TABLE and TRUNCATE TABLE commands?
What is a major difference between SQL Server 6.5 and 7.0 platform wise?
What is new philosophy for database devises for SQL Server 7.0?
What is a traditional Network Library for SQL Servers?
If you encounter this kind of an error message, what you need to look into to solve this problem?
What's the difference between a primary key and a unique key?
What are cursors? Explain different types of cursors? What are the disadvantages of cursors? How to avoid cursors?
