Why is the XLOCK table hint broken?

(Daniel Janik) Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources that the query accesses.

Register to Read