SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1078 Page Views: 

Point out some disadvantages of CURSORS?



Posted By: Avi Date: 1 October 2010 12:25:08 PM
 Answer:

1. They Keep the network busy because of there roundtrip. 2. It is time consuming , so decreases the performance of the task by slowing down the process. 3. Since they use large amount of temporary space and resources, they are very costly.


Posted By: avibtech


Date: 1 October 2010 12:25:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image dfdxNh
Related Questions
SQL Server : What is the basic concept of Serialization?

What is the basic concept of Serialization?

Serialization is the highest level of isolation. When Serialization is implemented then there will b....
Category: SQL Server Date: 10/1/2010 11:43:07 AM
SQL Server : Write the query to Select the name of the product whose total sales is 20 form the following table named sales:-
PID    Pname      Sale
1        Soap         5
2        Brush       10
3        Tea          8
1        Soap        12
2        Brush       5

Write the query to Select the name of the product whose total sales is 20 form the following table n....

select Pname from sales group by PID having sum(sale)=130
Category: SQL Server Date: 10/1/2010 11:42:07 AM
SQL Server : What will be returned with @@identity T-Sql?

What will be returned with @@identity T-Sql?

It will return the last inserted identity value. It will return a numeric value. So whenever a row ....
Category: SQL Server Date: 10/1/2010 11:41:07 AM
SQL Server : Why there is a need to use secondary database file when the same work can be done with primary databse files?

Why there is a need to use secondary database file when the same work can be done with primary datab....

Secondary files can be spread over multiple disks which will enhance the I/O operations.
Category: SQL Server Date: 10/1/2010 11:40:07 AM
SQL Server : What will be the result of the following query ? Explain your answer.
create table  tempo 
(sno INT, item_code nvarchar(2)) ;
 
insert into tempo
select 1, '0' UNION 
select 2, '11' UNION 
select 3, '12' UNION 
select 4,'0' UNION 
select 5,'0' 
 
update t

What will be the result of the following query ? Explain your answer. create table tempo (sno INT,....

The given query will result inot 3 rows. Sno item_code 1 4 5 ....
Category: SQL Server Date: 10/1/2010 11:38:07 AM