A heap of clusters

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.
Presented by Ami Levin at SQLBits X
  • Downloads
  • SpeakerBIO

    Ami Levin is a Microsoft SQL Server MVP, with over 20 years of experience in the IT industry. For the past 14 years he has been consulting, teaching and speaking on SQL Server worldwide. He manages the Israeli SQL Server user group, moderates the local MSDN SQL Server support forum, and is a regular speaker at Microsoft conferences. Levin’s areas of expertise are data modeling, database design, T-SQL and performance tuning. He blogs and publishes regularly on sql-server-tuning.com.

  • Video