Advantages and Disadvantages of Cursor?
Answer Posted / vivekanand
Merits: Row by Row Validations, good choice for small set of records
De-Merits: it Increases Network Traffic, result to slowdown the Speed and Performance of the Database,
Consumes More Resources, bad choice for large set of records.
Cheers,Vivekanand
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is difference between delete and truncate commands?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What happens if the update subquery returns no rows in ms sql server?
What do you understand by physical_only option in dbcc checkdb?
How to use subqueries with the in operators in ms sql server?
What are data regions?
What is the purpose of linked server configuration in sql server?
What is the purpose of sql profiler in sql server? : sql server database administration
What will happen if a column containing char type data is changed to the nchar data type?
What is merge?
How many databases can we create in a single server?
How to start sql server browser service?
How to use user defined functions in expressions?
How do you delete a trigger?
How global temporary tables are represented and its scope?