How can you control the amount of free space in your index pages? : sql server DBA

1324

---

What is the importance of a recovery model? : sql server DBA

1041

---

What the different topologies in which replication can be configured? : sql server DBA

1282

---

What purpose does the model database server? : sql server DBA

1207

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1029

---

What are the recovery models for a database? : sql server DBA

1143

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1004

---

What the different types of replication and why are they used? : sql server DBA

1188

---

What are the different ways you can create databases in sql server? : sql server DBA

1147

---

What is dcl? : sql server DBA

1281

---

What is the difference between clustered and non-clustered index? : sql server DBA

1100

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1015

---

What is the default fill factor value? : sql server DBA

1143

---

What authentication modes does sql server support? : sql server DBA

1223

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1221

---