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
Read More...
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 table
Read More...
