Answer Posted / gangi naidu.k

In case of sql queries,it is possible to compile one query
at a time,but incase of stored procedure we can compile
bunch of queries at a time and also it is need at first
time only,suppose we need modification on queries,after
modifications no need to compile again in case of stored
procedures,but in case of sql queries we have to compile
every time.Stored procedure contain queries in compiled
format so execution also fast and tome saving.One more
thing is in case of stored procedures serurity also more.

What are the limitations/drawbacks or ssrs 2008 r2?

132

---

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

1110

---

Where the sql logs gets stored?

944

---

How to remove duplicate rows from table except one?

952

---

How to loop through result set objects using mssql_fetch_array()?

1031

---

Can you pass expressions to function parameters?

1040

---

Why can there be only one clustered index and not more than one?

936

---

Does partitioning improve performance?

920

---

How do indexes help, types?

924

---

What is tempdb database? : SQL Server Architecture

1122

---

What is database replication?

1088

---

Can you use order by when defining a view?

923

---

How to invoke a trigger on demand?

1039

---

What do mean by xml datatype?

1021

---

Tell me the phases a transaction has to undergo?

923

---