SQLServerCentral.com Content tagged Indexing, heap

Check status of HEAP tables

Fri, 09 Apr 2010 06:00:00 UT

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!

Check status of HEAP tables

Fri, 09 Apr 2010 06:00:00 UT

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!

Reasons Why You May Not Want to Use a Heap

Tue, 10 Mar 2009 06:00:00 UT

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.