SQL Server Internals for Query Tuning provides the internal details you need to know to make sure you can get the best performance from your SQL Server queries.
Click the REGISTER button to get more details.
Use the discount code sqlsug for 10% off!
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.
Kalen Delaney teaches the most advanced SQL Server courses in the world. Her 5-day course “SQL Server Internals and Tuning” is designed for advanced SQL Server professionals who want to know how SQL Server really works, in order to take maximum advantage of its potential.
SQLearning, Inc. © 2018