Standard SQL defines four isolation levels that can be set using the SET TRANSACTION ISOLATION LEVEL statement: Serializable, Repeatable Read, Read Committed, and Read Uncommitted. Although all of the ...

When we encountered excessive blocking issues with reports, one tempting solution was to use the WITH NOLOCK table hint to get the report running smoothly and avoid blocking behavior completely.