charles.gary (9/17/2008)
Isnt this an incorrect filter?where d.database_id = d.database_id and d.object_id = d.object_id
Also you can get more info on this from
http://msdn.microsoft.com/en-us/library/ms345405(SQL.90).aspx
This article will show you how to interpret the meaning of the columns and how to build indexes off of the results.
...and there is this link as well, right below the link you mention on the limitations of the missing-index methodology:
http://msdn.microsoft.com/en-us/library/ms345485(SQL.90).aspx
Thank you, I hadn't seen these links til now.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]