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 is encryption key?

137

---

What command do we use to rename a database?

1115

---

optimization techinques

2717

---

What is SQL Azure Data sync?

123

---

What is dbcc?

1179

---

How do I run a trace in sql server?

1036

---

What is a transact-sql statement batch in ms sql server?

1068

---

Describe the functionalities that views support.

1144

---

explain different types of constraints? : Sql server database administration

998

---

What is the benefit of normalization?

1129

---

which backup strategy you are following at ur company

2191

---

What is a matrix in ssrs?

158

---

What is difference between standardization and normalization?

1154

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

1041

---

what is a self join? : Sql server database administration

1117

---