Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Joseph Sack » Analyzing Data Storage - Ten SHOWCONTIG...
Add to briefcase

Analyzing Data Storage - Ten SHOWCONTIG Queries Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
IsaacGoGo
Posted Monday, July 12, 2004 3:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 5:16 AM
Points: 24, Visits: 51
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colu


Post #125957
ccadman
Posted Monday, August 16, 2004 9:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, March 26, 2010 7:51 AM
Points: 269, Visits: 8

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


Post #132038
Rick Todd
Posted Monday, August 16, 2004 10:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 11:35 AM
Points: 216, Visits: 417
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
Post #132071
philcart
Posted Monday, August 16, 2004 5:18 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:53 AM
Points: 2,692, Visits: 1,074
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.

Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #132135
ckempste
Posted Monday, August 16, 2004 7:46 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1

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"
Post #132145
bernard black
Posted Tuesday, August 16, 2005 9:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:54 AM
Points: 76, Visits: 336

Great Article.  I've been investigating performance issues and using SHOWCONTIG.  I'm going to use these queries.  Thanks.  bblack
Post #210894
Emelie Clarin
Posted Thursday, February 16, 2006 4:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 29, 2009 10:04 AM
Points: 7, Visits: 2
Thanks a lot for this great article.  I am investigating some performance issues and this is a big help.
Post #259241
Ahmed Bouzamondo
Posted Wednesday, September 26, 2007 11:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 15, 2007 5:21 PM
Points: 14, Visits: 11
Excellent article.

I want to ask why sometimes, we have rows where indexename is empty?
Thanks
Post #403155
jts_2003
Posted Tuesday, June 16, 2009 8:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:15 PM
Points: 1,060, Visits: 4,156
Just what I was looking for - most useful.
Thanks
Post #735686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.