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

Articles with tag heap Rss

Search for any content tagged heap

   Items 1 to 7 of 7   

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 | 738 reads

Using OVER() to Remove Duplicate Rows

Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.  Read more...
By Mike McQuillan 2016/11/08 | Source: SQLServerCentral.com | Category: over
Rating: |  Discuss |   Briefcase | 4,048 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 2016/02/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,968 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,429 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 | 3,081 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,230 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,143 reads
   Items 1 to 7 of 7