Joey on SQL Server Understanding Dirty Reads: What NOLOCK Does to Your Queries Let's break down when it's ideal to use the NOLOCK hint and when you should never use it. By Joey D'Antoni 01/21/2022 ...

However, with NOLOCK (even though "everyone" has used it at some point or another) is generally considered a last resort. Queries that use NOLOCK aren't guaranteed to return correct results or ...