For those of you waiting for the new "Inside SQL Server" book, it is actually out now.  Kalen decided to give it a name change, and the actual title is "SQL Server 2008 Internals".  I've written a chapter on how the Query...

A customer recently asked our support organization about an unexplained series of range locks that they were seeing on a DELETE to a table with a foreign key. Here is the repro:   1: create table Foo (FooId int not null primary key ) 2: create...