Forwarded Records: What an UPDATE Can Do to a Heap

· by · in

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…