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!
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.