Skip navigation

Useful Index Information Scripts for SQL Server 2005

Italian SQL Server MVP Davide Mauri has released four very useful scripts that simplify the usage of SQL Server 2005 DMVs to discover, analyze, and understand index usage and health. The queries are not rocket science, but they are long and rely on DMVs that you may not have learned about yet. They also provide useful and easy shortcuts to common questions on SQL Server 2005. Check them out at: I now use them a lot. So I'm sure you'll find them useful too. Great job, Davide, and thank you for sharing! Cheers, -Ke

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.