Brent Ozar has a new episode of Customers Say the Darndest Things:
I have never seen a T-SQL feature that people love as much as NOLOCK.
I keep thinking I’ve written enough blog posts about it, but a client came up with a new one:
We use SQL Server 2022’s Accelerated Database Recovery, which keeps copies of versions inside the table. Plus, we don’t use transactions – our inserts, updates, and deletes are done one table at a time, and your demos always have transactions in them, so we’re not affected.
That’s not how this works. That’s not how any of this works.
It might be because it’s early in the morning when I type this out, but I’m having a hard time even conceptualizing what the customer could be thinking here. Brent does lay it out in the comments below, however, and yeah, I’d still raise an eyebrow if someone said that out loud to me.
But the moral of the story is, find someone who loves you like T-SQL developers love NOLOCK.