This works in SQL Server 2005 or better.
SELECT * FROM sys.dm_db_missing_index_details
Too easy!
See this link for more information.
Comments are closed.