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: http://www.davidemauri.it/SqlScripts.aspx 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
0 comments
Hide comments