Answer / Athar Shakeel

Disadvantages of using stored procedures include: 1) Complexity - creating, maintaining, and modifying stored procedures can be time-consuming; 2) Limited reusability - while stored procedures are meant to be reused, they might not always be applicable for different situations or databases; 3) Locking issues - multiple users accessing the same stored procedure can cause blocking and locking issues, affecting performance; 4) Difficulty in debugging - tracing errors in stored procedures can be challenging compared to normal SQL statements.

How to view existing indexes on an given table using sp_help?

1 Answers  

---

What is difference between index seek vs. Index scan?

1 Answers  

---

How to manipulate data from one table to another table ?

1 Answers   MCN Solutions,

---

What is named query? : sql server analysis services, ssas

1 Answers  

---

What is logshipping and its purpose?

1 Answers  

---

What is the template in sql?

1 Answers  

---

How to sort the query output with order by clauses in ms sql server?

1 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

Do you know what is lock escalation?

1 Answers  

---

How to run sql server 2005 books online on your local system?

1 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

what operator performs pattern matching?

2 Answers  

---