can a database be shrunk with users active? : Sql server administration
is it important for a database administrator to understand the operating system and file access? : Sql server administration
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
How you can get a list of all the table constraints in a database? : Sql server administration
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
can an automatic recovery be initiated by a user? : Sql server administration
how can a database be repaired? : Sql server administration
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
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
what does the automatic recovery do? : Sql server administration
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
how can you check the level of fragmentation on a table? : Sql server administration
what stored procedure would you use to view lock information? : Sql server administration