Answer Posted / tmp

the main advantages is Execution Plan Retention and Reuse (SP are compiled and their execution plan is cached and used again to when the same SP is executed again)
http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/

What language is sql server written in?

1034

---

What are sub reports and how to create them?

139

---

List the different types of collation sensitivities in sql server?

1044

---

How to create a dynamic cursor with the dynamic option?

1047

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

1111

---

What is SQL Azure Data sync?

121

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1933

---

What are drillthrough reports?

155

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

987

---

What are two difference between sql azure and azure tables?

159

---

How to find the list of fixed hard drive and free space on server?

1202

---

what's the maximum size of a row? : Sql server database administration

1089

---

How to find the second highest salary of an employee?

1179

---

Why union all is faster than union?

913

---

Why does sql studio use a single registered database repository? : sql server management studio

1000

---