Answer / Sokesh

Cursors in SQL Server have several disadvantages, including:
1. Performance issues: Cursors can significantly decrease performance due to repeated reads and writes.
2. Increased resource consumption: Cursors require more memory and CPU resources compared to set-based operations.
3. Error handling: Handling errors within cursors can be complex and error-prone.
4. Scalability issues: Cursors are not suitable for large datasets and may cause scalability problems.

what's sql server? : Sql server database administration

1 Answers  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

What are different types of views?

1 Answers  

---

What is a Stored Procedure?

8 Answers  

---

What are the different types of backups that exist?

1 Answers   ADITI,

---

How to select true false based on column value in sql server?

1 Answers  

---

write an SQL query to list the employees who joined in the month of January?

1 Answers   Agilent, Amdocs,

---

What are the joins in sql server? : sql server database administration

1 Answers  

---

How network traffic be reduced by using the stored procedure?

1 Answers   Accenture,

---

What are logical/boolean operations in ms sql server?

1 Answers  

---

What is 4nf in normalization form?

1 Answers  

---

what is an index? : Sql server database administration

1 Answers  

---