Post reply

Analyzing Data Storage - Ten SHOWCONTIG Queries

  • July 12, 2004 at 3:43 pm

    #161885

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colu

  • August 16, 2004 at 9:00 am

    #519157

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

  • August 16, 2004 at 10:40 am

    #519180

    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

  • August 16, 2004 at 5:18 pm

    #519226

    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

  • August 16, 2004 at 7:46 pm

    #519232

    Hi there

    Great article, simple solution and very easy to extend.

    Thanks

    Cheers

    Chris K


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

  • August 16, 2005 at 9:45 am

    #582523

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

  • February 16, 2006 at 4:09 pm

    #621505

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

  • September 26, 2007 at 11:52 am

    #736476

    Excellent article.

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

    Thanks

  • June 16, 2009 at 8:12 am

    #1010202

    Just what I was looking for - most useful.

    Thanks

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

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