Engine Watch

database engine technology and SQL Server

November, 2005

Posts
  • Engine Watch

    Is lock grant in SQL Server First-In-First-Out (FIFO)?

    • 8 Comments
    Many people thought that lock grant in SQL Server was FIFO to avoid starvation problems. Think about it. If someone is able to get in front of you in a super market checkout queue, you may never be able to get out of the store. My friend Santtu who...
  • Engine Watch

    SQL 2005 shipped (11/7/2005)

    • 0 Comments
    What an exciting five years. Areas I personally contributed: snapshot isolation and RCSI; page allocation and free space management; tempdb and a few other smaller things.
Page 1 of 1 (2 items)