What is data compression? : sql server database administration

1017

---

What is blocking and how would you troubleshoot it? : sql server database administration

1096

---

What is sql profiler. What are the default templates with it? : sql server database administration

1106

---

Where the sql logs gets stored? : sql server database administration

1014

---

What stored by the model? : sql server database administration

1003

---

How do you test your database? : sql server database administration

1070

---

How to view the error log for any specific instance? : sql server database administration

1098

---

What is the purpose of sql profiler in sql server? : sql server database administration

1159

---

Can we perform backup restore operation on tempdb? : sql server database administration

1046

---

Can you move the resources after pausing the node? : sql server database administration

1164

---

What should be the fill factor for indexes created on tables? : sql server database administration

1178

---

What is lock escalation? : sql server database administration

1198

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1079

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1030

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1082

---