To summarize the difference between the way SQL Server has traditionally taken locks and optimized locking, I'll defer to my MVP colleague Aaron Bertrand, who, in his post on the topic, said, "Instead ...