[Video] Office Hours: Off St. Thomas
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 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…
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 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?