Forwarded Records: the Back-Pointer and the Trip Home
This post is part of the series. The contents page lists every part in order. Note: a self-contained MCVE reproducing every result in this post is included at the end - see "The MCVE: run…
Forwarded Records: What an UPDATE Can Do to a Heap
This post is part of the series. The contents page lists every part in order. A heap, a table with no clustered index, has a failure mode that clustered tables do not: an UPDATE that…