Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Indexing, Tuning Rss

   Items 1 to 6 of 6   
 

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2015/02/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,853 reads

Unique Identifier as Clustered index

This script selects clustered indexes containing only a uniqueidentifier column  Read more...
By Wilfred van Dijk 2013/10/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,173 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2015/02/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,853 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 | 2,058 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2015/02/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,853 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 | 2,058 reads
   Items 1 to 6 of 6   
 
Tags
administration (2)    
performance tuning (2)    
heap (1)    
maintenance (1)    
unique identifier (1)