Forwarded Records: the Back-Pointer and the Trip Home
Note: a self-contained MCVE reproducing every result in this post is included at the end - see "The MCVE: run it yourself". Hugo Kornelis recently challenged a sentence in my post on how SQL Server…
Forwarded Records: What an UPDATE Can Do to a Heap
A heap, a table with no clustered index, has a failure mode that clustered tables do not: an UPDATE that makes a row larger can force it to physically move, and SQL Server leaves a…