Locking Hints Make Everything Confusing
Many people will go their entire lives without using or seeing a lock hint other than NOLOCK. Thankfully, NOLOCK only ever leads to weird errors and incorrect results. You’ll probably never have to deal with the stuff I’m about to talk about here.
erikdarlingdata.com