Primary-Key

Tag: primary-key

Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes (Dear SQL DBA Episode 28)

Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes (Dear SQL DBA Episode 28)

on February 2, 2017

Category: indexing
Tags: architecture , clustered , columnstore , database-design , dear-sql-dba , heap , index , modeling , nonclustered , primary-key , rowstore

I see HEAP tables are found even when I know those tables have a clustered index, and I see a lot of forwarded records. This happens to 5 tables in my database. I can see the clustered and in some ones the non-clustered indexes… why are some scripts reporting them as heaps?

Continue reading