Gregg Stark has created a very nice
query that is a great tool for optimizing indexes (indices)
in SQL Server 2005.
Here's the query:
SELECT o.name AS object_name, i.name AS index_name
, i.type_desc, u.user_seeks, u.user_scans, u.user_lookups
, u.user_updates, u.last_user_seek, u.last_user_scan
, ...
[More]
573ae19c-dbb2-42c4-90e5-0dbcb2090a6e|1|4.0
SQL Server
index, performance