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

Content with tag heap Rss

   Items 1 to 7 of 7   
 

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,346 reads

Identify and Correct SQL Server Forwarded Records

Forwarded records in SQL Server can cause performance issues on heap tables because the record outgrows the page and the database engine uses pointers to reference the data. The best practice is to have a clustered index on every table, however, sometimes there are cases when a clustered index is not needed.   Read more...
By Additional Articles 2013/07/09 | Source: MSSQLTips.com | Category: heap
Rating: (not yet rated)  Rate this |   Briefcase | 2,855 reads

Can a Table Really Have a Clustered Index?

A table doesn't so much "have" a clustered index as a table "is" a clustered index.  Read more...
By Hakim Ali 2012/12/24 | Source: SQLServerCentral.com | Category: bookmark lookup
Rating: |  Discuss |   Briefcase | 8,191 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,001 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,001 reads

Estimating the table size...

This is an effort to program the "Estimating the Table size" section given in BOL.   Read more...
By sql frenzy 2009/07/02 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 1,602 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 | 2,832 reads
   Items 1 to 7 of 7   
 
Tags
clustered index (2)    
indexing (2)    
administration (1)    
bookmark lookup (1)    
calculate (1)    
clustering (1)    
estimate (1)    
forwarded records (1)    
index (1)    
non-clustered (1)    
nonclustered index (1)    
non-clustered index (1)    
performance tuning (1)    
size (1)    
space (1)    
table (1)    
tuning (1)    
used (1)