SQL Server Cursors Interview Question:

Explain the disadvantages of cursors?

Submitted by: Administrator

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
Submitted by: Administrator