What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

what is the main difference between after trigger and instead trigger.

2 Answers  

---

Repair mdf file

2 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

Does sql server 2000 full-text search support clustering?

0 Answers  

---

What command would you use to create an index?

0 Answers  

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

List the types of recovery model available in sql server?

0 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

When is the use of update_statistics command?

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

---