LoslegenKostenlos loslegen

Comparing WITH (NOLOCK) & READ UNCOMMITTED

Your colleague needs to read some uncommitted data within a transaction. He has to decide whether to use WITH (NOLOCK) option or the READ UNCOMMITTED isolation level, but he is not sure about the differences between both options.

Can you help him to clarify the differences between using WITH (NOLOCK) option and the READ UNCOMMITTED isolation level?

Diese Übung ist Teil des Kurses

Transactions and Error Handling in SQL Server

Kurs anzeigen

Interaktive Übung

Setze die Theorie in einer unserer interaktiven Übungen in die Praxis um

Übung starten