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

• What does the DEALLOCATE statement do in SQL Server 2005?
• You are troubleshooting a Service Broker application ...
• When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
• Can you use Full-text search to index this column?
• What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?
• On which port does the dedicated administrator connection listen in SQL Server 2005?
• What does this return?
• How are modified extents tracked in SQL Server 2005 (which internal structures)?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?
• More...