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 master database? : SQL Server Architecture

960

---

What is partition, how will you implement it? : sql server analysis services, ssas

999

---

what is the difference between Delete and Truncate command in SQL

1088

---

What functions can a view be used to performed?

1010

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2675

---

What have included columns when we talk about sql server indexing?

998

---

What is page in sql server?

908

---

How to receive output values from stored procedures?

1064

---

Explain multiserver query

972

---

What is the stored procedure?

954

---

How secure is sql server database?

962

---

What are the different types of backups avaialabe in sql server 2005?

977

---

Ms sql server index?

1018

---

How can you insert values in multiple rows using one Insert statement?

1046

---

Explain the steps to use transact-sql cursor?

971

---