Answer Posted / sanjeev maurya

Extended Procedure

What is a trigger in sql server?

1172

---

What are the new features of sql server 2008 r2 reporting service?

209

---

Distinguish between nested subquery and correlated subquery?

1043

---

Can primary key be a foreign key?

1058

---

what is the primary use of the model database? : Sql server administration

1050

---

What is replication and database mirroring?

1047

---

What is an identity?

1018

---

Difference between report and query parameter. Why do we need different type of parameter?

953

---

What are the steps you will take to improve the performance of a poor performing query?

979

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

987

---

Do you know what are acid properties?

1078

---

What is the boxing and unboxing concept in .net?

917

---

Define msdb database?

1016

---

How does clustered and non clustered index work?

923

---

What are the different types of sub-queries?

1043

---