Some of y’all, bless your hearts, are really, really, really in love with NOLOCK.
I’ve shown you how you get incorrect results when someone’s updating the rows, and I’ve shown how you get wrong-o results when someone’s updating unrelated rows. It doesn’t matter – there’s always one of you out there who believes NOLOCK is okay in their special situation.
The latest NOLOCK defender left me an angry comment:
I challenge you to show us one example of using nolock on a static database with incorrect results.
No problemo – I assume you mean tables that aren’t getting inserts, updates, or