SQLBits 2012

A heap of clusters

An in-depth dive into physical table structures
A common myth claims that heaps are (mostly) evil and that every table should have a clustered index.  In this session we will explore the fine details of both heaps and clusters and see if there is indeed any truth to this myth. We will look at (semi) real-life examples and understand when and why it is best to use heaps and clusters regarding multiple aspects of performance and maintenance.