what is the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

explain different types of joins? : Sql server database administration

0 Answers  

---

Explain the disadvantages of cursors?

0 Answers  

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

---

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,

---

What is triggers and its types?

0 Answers  

---

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

---

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

What is exporting utility?

0 Answers  

---

How do I find query history in sql server?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---