Hugo Kornelis disentangles two new features in SQL Server 2025:
One of these two features is Transaction ID (TID) Locking. Slated to end the memory waste of thousands of individual row locks, and the concurrency killer of lock escalation. What it is, how does it work, what are the limitations, and do we really get a free lunch?
Click through for the video, though I am firmly wedded to the idea that TANSTAAFL. I say this without spoiling any part of the video.