Twas the Night Before the MCM ...

T'was the Night Before the MCM ...
SQL Server MCM starts tomorrow. My wife thinks it's cute that I'm excited. The...

Top 6 Myths of Transaction Logs

Top 6 Myths of Transaction Logs I think there is a lot of misunderstanding concerning database transaction logs in SQL Server. I...

Breaking Down TempDB Contention

Breaking Down TempDB Contention 
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...

T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?

T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?
This blog entry is participating in T-SQL Tuesday #004, hosted this month...

SQL LiteSpeed Error: XML returned from Engine was invalid

 SQL LiteSpeed Error: XML returned from Engine was invalid
This is a very common error returned from SQL LiteSpeed. So what...

Breaking Down TempDB Contention

Breaking Down TempDB Contention 
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...

Do I have to snatch the pebble?

Attending the Microsoft Certified Master (MCM) program in March
This is the most excited I've been since I heard that Alice...

SQL Saturday returns to Redmond, WA

SQL Saturday returns to Redmond, WA, Saturday, June 12, 2010, in the Microsoft Commons.

I have submitted 2 proposals for presentations,...

SQLSaturday 26 Session Files

SQLSaturday 26 Sessions: 10/3 in Redmond, WA
Thanks to everyone that attended my sessions at SQLSaturday 26 in Redmond, WA on...

What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?

Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005? This question was asked on a technical discussion group. My reply follows.