Search code examples
sqlsql-servertransaction-isolation

NOLOCK vs. Transaction Isolation Level

What's the difference between using "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" and NOLOCK? Is one better than the other?

Solution

  • They're the same thing, just scoped differently. NOLOCK is placed on a per table basis and SET Transaction... can be placed as a block.