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?
Deze oefening maakt deel uit van de cursus
Transactions and Error Handling in SQL Server
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen