THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » metadata » locking   (RSS)
  • 24 Hours of PASS – Locking and Blocking Q&A

    Thanks to everyone who attended my 24HOP session on Wednesday, September 7. My favorite part is always the Q&A. I wish there was more time to do live Q&A, but because there’s not, I get to turn it into a blog post! My session was a snippet of what I will be talking about in my pre-con for the big PASS Summit at the end of next month. ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 13, 2016
  • Did You Know? Turning Off Locking

    Back when the lock manager was rewritten for SQL Server 7, and row level locking was added to the product, the procedure sp_indexoption gave us the ability to turn OFF either row or page locks or both, for one particular index, or for a table and all the indexes on it. I must admit, I rarely found this option to be the solution to any sticky ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 7, 2012
  • Geek City: What do you intend with that lock?

    Way back in the olden days, prior to SQL Server 7, I already knew that the lock manager was one of the most complex and resource intensive parts of SQL Server. Keeping track of every lock held, who was waiting for that lock, who could be granted the lock, and who was next in line for the data if the lock was released was a lot for SQL Server to ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 11, 2009
Privacy Statement