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

Content with tags Administration, Tuning, Indexing Rss

   Items 1 to 4 of 4   
 

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,741 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...
By Wilfred van Dijk 2010/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,994 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,741 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...
By Wilfred van Dijk 2010/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,994 reads
   Items 1 to 4 of 4   
 
Tags
performance tuning (2)    
heap (1)    
maintenance (1)