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
Explain different types of Normalization.
What is CTE in SQL
How will you add a dimension to cube? : sql server analysis services, ssas
What is a trigger in sql server?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Can we use max in where clause?
How can we improve performance by using SQL Server profiler?
What is the openxml statement in sql server?
how you can deploy an ssrs report?
Explain the concept of recursive stored procedure.
What is database dimension? : sql server analysis services, ssas
What is the use of custom fields in report?
What is used to replicate sessions between instances in coldfusion clusters?
What are cursors and when they are useful?
Explain tablesample?
