Heap modification internals

You’ve seen how SQL Server stores data in a heap. Now you can look at what SQL Server actually does internally when your heap data is modified. Modifying data in an index, which includes a table with a clustered index, is a completely separate topic and is covered in detail in Chapter 7. As a rule of thumb, you should almost always have a clustered index on a table. In some cases you might be better off with a heap, such as when the most important factor is the speed of INSERT operations, but until you do thorough testing to establish that you have such a situation, having a clustered index is better than having no organization to your data at all. In Chapter 7, you’ll see the benefits and tradeoffs of clustered and ...

Get Microsoft SQL Server 2012 Internals now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.