SQLDay is the largest conference focused on Microsoft Data Platform – databases, Big Data, Business Intelligence and advanced data analysis.
Demos and presentation for my Exploring the Plan Cache session at SQLDay 2018 can be downloaded here.
Demos and presentation for my Concurrency session at SQLDay 2018 can be downloaded here.
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.