I’m at sea again, this time cruising aboard the Disney Treasure off of St. Thomas. Let’s go through your top-voted questions from https://pollgab.com/room/brento.
00:00 Start 01:40 DbaMan: You have been reulctant to turn on ADR. It is required for optimized locing in SQL Server 2025. What is your view of ADR + Optimized locking? Is it almost an automatic yes, or should it only be enabled if we have BIG problems with locking/blocking? 05:32 TeaEarlGrayHot: Why is the size of the persistent version store in SQL with optimized locking a concern while in postgres and mysql that store