Analyzing Data Storage - Ten SHOWCONTIG Queries

  • Comments posted to this topic are about the content posted at

  • Excellent!  I am currently evaluating a restucturing of our database and this really opened my eyes to some shocking things.  Thanks!

  • This is a great article. One of those articles that will nudge a DBA like myself into looking at this info for our databases. Thanks for the great work!

    Rick Todd

  • Nice article.

    Only thing I would change is using a permanent table instead of a temporary one.

    Then you can accumulate the data and perform some analysis on it.

    Colt 45 - the original point and click interface

  • Hi there

    Great article, simple solution and very easy to extend.



    Chris K

    Chris Kempster
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

  • Great Article.  I've been investigating performance issues and using SHOWCONTIG.  I'm going to use these queries.  Thanks.  bblack

  • Thanks a lot for this great article.  I am investigating some performance issues and this is a big help.

  • Excellent article.

    I want to ask why sometimes, we have rows where indexename is empty?


  • Just what I was looking for - most useful.


Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply