Erik Darling ponders several techniques for solving the last page contention problem in SQL Server:
If one dare go looking, a list of Microsoft Approved™ solutions for dealing with last page contention exists.
I’m going to walk through my experiences with them in different scenarios, so you get a better understanding of which ones work best, and which ones can be tough to implement.
Read the whole thing.