Hello!

Thank-you all for your interest, and valuable feedback.

Some of the points mentioned in the feedback are really great. I will research them and update the article as necessary.

However, for some suggestions (filtered indexes, using partitioned tables, etc) are all great in hindsight. As mentioned, this is based upon a live example, and the schema was in place and no changes were allowed (at least in the case of the heap). That being said, I agree that if a purging solution is being designed from scratch, yes, these are some of the features that absolutely should be used.