When updating a record in a heap, SQL Server attempts to fit it on the same page. If the page is full, the record is moved to a new page, and the old one is replaced with a forwarding pointer. The updated version of the row is referred to as a forwarded record.
Comments
Post a Comment