Answer Posted / pervej munjal
Cursor plays there row quite nicely but although there are
some disadvantage of Cursor .
Because we know cursor doing roundtrip it will make network
line busy and also make time consuming methods. First of
all select query gernate output and after that cursor goes
one by one so roundtrip happen.Another disadvange of cursor
are ther are too costly because they require lot of
resources and temporary storage so network is quite busy.
Site of Dot net and sql server
("http://www.dotnetquestion.info")
<a href="http://www.dotnetquestion.info">link</a>
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is a scheduled job or what is a scheduled task?
Does view occupy space?
Can we do dml on views?
What is self contained sub query?
Where can you add custom error messages to sql server?
What is sql or structured query language?
What is standby servers? Explain types of standby servers.
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is a view in sql?
How can I check that whether automatic statistic update is enabled or not?
What is a coalesce function?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What kind of problems occurs if we do not implement proper locking strategy?
How can we solve concurrency problems?
