SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Indexing, heap Rss

   Items 1 to 7 of 7   
 

The DBA's Essential Index Monitoring and Maintenance Tasks

Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.  Read more...
By John F. Tamburo 2018/03/09 (first published: 2016/02/15) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,820 reads

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 749 reads

The DBA's Essential Index Monitoring and Maintenance Tasks

Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.  Read more...
By John F. Tamburo 2018/03/09 (first published: 2016/02/15) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,820 reads

Tables and Clustered Indexes Part 2

A table does not so much 'have' a clustered index as a table 'is' a clustered index.  Read more...
By Hakim Ali 2013/07/22 | Source: SQLServerCentral.com | Category: clustered index
Rating: |  Discuss |   Briefcase | 6,436 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,074 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,074 reads

Reasons Why You May Not Want to Use a Heap

For a book project I am working on, I have started compiling a list of reasons why heaps aren't usually a good choice when designing a database. Now, I didn't say that heaps are always bad, but in most cases, I think they should be avoided so pleae read the list to see why.  Read more...
By Additional Articles 2009/03/10 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 3,213 reads
   Items 1 to 7 of 7   
 
Tags
clustered index (2)    
achrchive compression (1)    
administration (1)    
cluster (1)    
columnstore index (1)    
compression (1)    
duplicate indexes (1)    
missing indexes (1)    
non-clustered index (1)    
page level compression (1)    
performance tuning (1)    
sp_spaceused (1)    
space usage (1)    
tuning (1)