SQL Server: How to Remove Forwarded Records of a Heap Table?

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In the previous two posts, I shared basic about Forwarding Records of Heap Table and shared a script to find the count of Forwarded Records in SQL Server.

In this post, I am sharing a practical demonstration on Forwarding Records like generate Forwarding Records and then Remove those Forwarding Records.

Please check the below full demonstration:

Create a sample HEAP table:

Insert sample records with VARCHAR(5) size:

Now, Update the data from VARCHAR(5) to VARCHAR(31):

Check the count of Forwarding Records:

For removing Forwarding Records, we should REBUILD the table:

Now, Check the new count of Forwarding Records:
The count is 0 now.