THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

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:

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,

-Kev

Published Friday, August 31, 2007 6:31 PM by KKline

Comment Notification

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 RSS

Comments

 

JOhn said:

Such valid points. Only wish people would listen to what you say here!

September 2, 2007 9:43 AM
 

Joe Webb said:

Good info!

Also, for those who may not already be aware, there's a good article on indexing and statistics over on TechNet.

http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx

Joe

September 4, 2007 7:30 AM
 

KKline said:

Thanks, John and Joe.  I haven't read the TechNet article yet, but now it's on my to-do list.

Best regards,

-Kev

September 7, 2007 3:25 PM

Leave a Comment

(required) 
(required) 
Submit

About KKline

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.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement