Back to All Events
Earlier Event: February 10
Statistics Session at SQL Saturday Redmond
Later Event: May 14
Speaking at SQLDay
Stay Tuned For More Events! In the meantime...
Geek City: What's Worse Than a Table Scan?
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.
