More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate?
You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate? You haven't been running Profiler, but you're wondering if you can determine what indexes might be more helpful for your users. What can you do?
Answer: Query sys.dm_db_missing_index_details.
Explanation: The database engine in SQL Server 2005 collects information on missing indexes based on attempts by the query optimizer. You can use this to determine if there might be better indexes you can create. It IS NOT the list of indexes you should create.
(Continued on next question...)