Davide Mauri Blog

Experiences with SQL Server

Useful index scripts

At this address

http://www.davidemauri.it/SqlScripts.aspx

i've released four scripts that simplify the usage of SQL Server 2005 DMVs to discover, analyze and understand indexes usage and health.

They are nothing exceptional, juts a shortcut to common (but long to write)
queries.

I use them a lot, maybe they're of some use to other DBAs :-)