Robert Klimes
SSCoach
Points: 17865
More actions
October 7, 2011 at 1:44 pm
#1391961
Have a look at the sys.dm_db_missing_index_details (http://msdn.microsoft.com/en-us/library/ms345434.aspx)view.
also here is a blog post with some handy scripts using the dmv
http://sqlserverperformance.wordpress.com/2007/10/12/five-very-useful-index-selection-queries-for-sql-server-2005/
Bob-----------------------------------------------------------------------------How to post to get the best help[/url]
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply