Monthly Archives: Dec 2012
Confusing Signage in SQL Server 2008 R2 Service Pack 2
The other day whilst applying SQL Server 2008 R2 Service Pack 2 to an instance, I had cause to cancel out of the installation. I did this at the pre-flight check stage by clicking the “Cancel” button. Upon doing this … Continue reading
Posted in Uncategorized
6 Comments
Puzzling Lock Escalation Behaviour in a Partitioned Table
Here’s some lock escalation behaviour that I found interesting and thought I’d share. This is a link to all the T-SQL in this blog if you’d like to play along with me:- Play along with SQL Let’s start by creating a … Continue reading
Posted in Indexing, Table Partitioning
Leave a comment
The results, if any, should be discarded... 