which table keeps the locking information? : Sql server administration

1140

---

what is a mixed extent? : Sql server administration

1177

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

1038

---

where can you add custom error messages to sql server? : Sql server administration

1177

---

how you can get the list of largest tables in a database? : Sql server administration

1105

---

can a database be shrunk with users active? : Sql server administration

1063

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1078

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1161

---

How you can get a list of all the table constraints in a database? : Sql server administration

1096

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

1010

---

can an automatic recovery be initiated by a user? : Sql server administration

996

---

how can a database be repaired? : Sql server administration

1018

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

1048

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1314

---

what does the automatic recovery do? : Sql server administration

1081

---