What is your recommendation for a query running very slow? : sql server database administration

1045

---

What is stored in the mssqlsystemresource database? : sql server database administration

1030

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1151

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1040

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

932

---

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

1011

---

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

1022

---

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

1083

---

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

1104

---

What are the dmvs? : sql server database administration

1054

---

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

978

---

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

1025

---

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

1041

---

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

1283

---

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

1043

---