THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » metadata » locking   (RSS)
Sorry, but there are no more tags available to filter with.
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement