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?