SQL Server Cursors Question: Download Questions PDF
Can you explain the disadvantages/limitation of the cursor?
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.
While data processing, it issues locks on part of the table, or on the whole table.
Download MS SQL Server Cursors Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is Explicit cursors? | Explain the disadvantages of cursors? |