How do we distinguish a normal variable length column value from one containing a complex value like a row-overflow pointer, back pointer or a sparse vector?

Learn how a forwarded record in a heap stores a back pointer that refers to the original record from where it's forwarded.

Learn the internals of how a record gets forwarded in a heap. Specifically we'll look at the forwarding stub that is left behind, pointing at the forwarded record.