What are system databases into sql server (2005/2008) : sql server database administration

1052

---

What are truncate options available in sql server? : sql server database administration

1083

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1125

---

What is database isolation in sql server? : sql server database administration

1153

---

What are the dmvs? : sql server database administration

1120

---

What is policy based management (pbm)? : sql server database administration

1030

---

Where can you find the error log information? : sql server database administration

1072

---

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

1089

---

How to truncate the log in sql server 2012? : sql server database administration

1345

---

What is the difference between lock, block and deadlock? : sql server database administration

1092

---

Explain the different types of backups available in sql server? : sql server database administration

987

---

What stored by the master? : sql server database administration

1180

---

What stored by the msdb? : sql server database administration

1052

---

What are the joins in sql server? : sql server database administration

1050

---

Describe the left outer join & right outer join. : sql server database administration

1037

---