Interested to Buy Any Domain ? << Click Here >> for more details...
what are the disadvantages of cursors? : Sql server database administration
- 1 Answers
- 1117 Views
- I also Faced
- E-Mail Answers
Answer Posted / Lavi Sahu
"Cursors in SQL Server can have several disadvantages. They can lead to performance issues due to their iterative nature and can consume a lot of system resources. Cursors can also make the code more complex, harder to maintain, and less scalable. Additionally, cursors can sometimes result in poor query plan reuse, which can further impact performance."n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you index views?
What is the difference between upgrade and migration in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are the properties of the transaction?
How to provide default values to function parameters?
What is self contained sub query?
What is the primary use of the model database?
How to convert character strings into numeric values?
what is the difference between openrowset and openquery?
What are wait types?
Does view occupy space?
How can I check that whether automatic statistic update is enabled or not?
Disadvantages of the indexes?
What is a coalesce function?
Why and when do stored procedure recompile?
