Why should we go for stored procedures? Why not direct queries?

1106

---

What number sorts of privileges are accessible in sql?

1039

---

What are the difference between primary keys and foreign keys?

974

---

Define normalisation?

1118

---

How can you control the amount of free space in your index pages?

1061

---

What is sql sandbox in sql server?

1241

---

What is dbcc?

1147

---

How to delete exactly duplicate records from a table?

1069

---

What is the contrast amongst drop and truncate?

1038

---

What are data files?

1048

---

What is the difference between a clustered index and a non-clustered index?

993

---

What are the difference between clustered and a non-clustered index?

1048

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1211

---

What is the use of nvl work?

1010

---

How to optimize stored procedures in sql server?

1192

---