SQL Server Cursors Question:
Download Job Interview Questions and Answers PDF
Explain the disadvantages of cursors?
Answer:
Disadvantages of cursors
Uses more resources because Each time you fetch a row from the cursor, it results in a network roundtrip
There are restrictions on the SELECT statements that can be used.
Because of the round trips, performance and speed is slow
Uses more resources because Each time you fetch a row from the cursor, it results in a network roundtrip
There are restrictions on the SELECT statements that can be used.
Because of the round trips, performance and speed is slow
Download MS SQL Server Cursors Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can you explain the disadvantages/limitation of the cursor? | How to avoid cursors? |