Aaron Bertrand carries a lantern around Athens, searching for an honest NOLOCK:
In Part 1 of this series, I showed how to identify “NOLOCK in DML” patterns within a single statement using a Visitor pattern. In Part 2, I showed how to find those patterns in procedure and trigger bodies across multiple databases and instances. I still need to show how to eliminate false positives without tedious visual inspection.
Read on to see how we can narrow down the likelihood of a false positive when searching for the worst sorts of NOLOCK queries.