New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning

Posted on: September 11, 2018 4:31 am

New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning

Posted on: June 11, 2018 9:19 am

Low priority locking wait types

Posted on: October 16, 2015 2:48 am

When is fast recovery used?

Posted on: September 15, 2014 1:40 pm

Database mirroring: avoiding ‘cannot obtain a LOCK resource’ problems

Posted on: January 15, 2013 1:35 pm

SOS_SCHEDULER_YIELD waits and the LOCK_HASH spinlock

Posted on: April 26, 2011 11:41 am

A SQL Server DBA myth a day: (23/30) lock escalation

Posted on: April 23, 2010 12:14 pm

A SQL Server DBA myth a day: (8/30) unicorns, rainbows, and online index operations

Posted on: April 8, 2010 7:24 am

Lock logging and fast recovery

Posted on: November 13, 2009 1:24 pm

Investigating locking and deadlocking with %%lockres%%

Posted on: May 30, 2009 3:41 pm

Getting historical deadlock info using extended events

Posted on: February 23, 2009 1:49 pm

TechNet Magazine: February 2009 SQL Q&A column

Posted on: January 16, 2009 10:15 am

Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)

Posted on: June 8, 2008 5:12 pm

SQL Server 2008 JumpStart

Posted on: February 15, 2008 12:38 am

SQL Server 2008: Partition-level lock escalation details and examples

Posted on: January 14, 2008 10:10 pm

Search Engine Q&A #10: When are pages from a truncated table reused?

Posted on: December 5, 2007 7:37 pm

SQL Server 2008: Lock escalation changes

Posted on: October 2, 2007 10:06 pm