Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1079

---

What is fill factor? : sql server DBA

1310

---

What is the default port no on which sql server listens? : sql server DBA

1224

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1111

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1167

---

What are the commands used in dcl? : sql server DBA

1133

---

What are the operating modes in which database mirroring runs? : sql server DBA

1242

---

What is a system database and what is a user database? : sql server DBA

1318

---

How do you open a cluster administrator? : sql server DBA

1153

---

Which autogrowth database setting is good? : sql server DBA

1245

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1372

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1125

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1251

---

What are the different types of indexes available in sql server? : sql server DBA

1270

---

What is left outer join in sql server joins?

1111

---