which table keeps the locking information? : Sql server administration
what is a mixed extent? : Sql server administration
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
where can you add custom error messages to sql server? : Sql server administration
how you can get the list of largest tables in a database? : Sql server administration
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