Network, develop and share your data knowledge at THE conference for leading data professionals. SQLBits is the largest SQL Server conference in Europe for data professionals, led by Microsoft Data Platform experts.
UPDATE locks are not really a separate kind of lock, but rather are a hybrid of SHARED and EXCLUSIVE locks. And contrary to what you might think, UPDATE locks are not just acquired for UPDATE operations. A transaction acquires this kind of lock when SQL Server executes a data modification operation but first needs to perform a search to find the resource to modify.