NOLOCK can cause blocking!!!!! |
|
Really awesome video from Kendra Little at BrentOzar.com on the use of NOLOCK. She shows how NOLOCK can cause blocking. In brief, NOLOCK acquires a Schema Stability Lock(SCH-S) which is incompatible with Schema Modification Lock(SCH-M).