DBA > Job Interview Questions > Microsoft SQL Server FAQs

You restart your SQL Server on a Sunday morning

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You restart your SQL Server on a Sunday morning after some maintenance ...

You restart your SQL Server on a Sunday morning after some maintenance and decide to do some other work before people come back Monday and begin using the server. Since you are the only person on the server, you decide to query the sys.dm_db_index_usage_stats DMV and get what?

Answer: You don't get any information back.

Explanation: While this DMV does indeed store information about index usage while the server is running, it is cleared on each server restart and does not maintain this information across time. Therefore you would not get any information.

(Continued on next question...)

Other Job Interview Questions