Indexes

In my post about last page contention I proposed heaps as a possible solution for that problem. But before you start using heaps, there are a few consequences that must…

Last page contention happens when many concurrent threads are trying to modify the same page of a rowstore index (clustered or non-clustered). Only one thread can add or change data…

Rowstore Index fragmentation can be divided into two groups: internal fragmentation which is measured in page density and external fragmentation that relates to the logical order the pages themselves are…

Fill factor defines how much space on the page should be used to store data during (rowstore) index creation, index rebuilding or index reorganizing. It has traditionally been used to…

What indexes are and how they are organized internally is very much a 101 topic. For those unfamiliar I can recommend Brent Ozars free class “How to Think Like the…