Answer Posted / somu.kattikar

Using Co-Related Sub Queries

What are the differences between stored procedure and the dynamic sql?

760

---

Explain ranking functions?

776

---

How to modify existing triggers using "alter trigger"?

698

---

How can I change procedure name in sql server?

695

---

How do you handle datasets larger than 50 gb?

154

---

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

732

---

What are the advantages of using stored procedures in sql server?

693

---

What is clustered index

742

---

How to create a trigger for insert only?

755

---

What is a trace frag?

822

---

What is data set in report?

112

---

What is the difference between primary key and unique constraints?

667

---

How do I find the query plan in sql server?

705

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

720

---

What is difference between materialized view and view?

685

---