Debugging query timeouts by sampling blocking – part 2

In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...

Free E-Book on SQL Server 2012, Great Job by Ross Mistry and Stacia Misner (yes, they have done it again :)

Free E-Book: Introduction to SQL Server 2012

Ross Mistry and Stacia Misner have again done a wonderful job on this free...

Get Free Learning

A couple of different events going on today and tomorrow:
Today (03/20) at 3pm CDT - "Choose Your Own Adventure: Performance Tuning"...

Microsoft Releases SQL Server 2008 SP2 Cumulative Update 9

Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has...

PASS for Today (and Tomorrow)

I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...

Seldom Used Indexes

On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then possibly a manager or client.  Usually this comes up...

SSIS: Script Component Asynchronous Transformation

The SSIS script component can be configured to use synchronous or asynchronous outputs.  If the script component is configured for...

24-Hours of PASS - Be on-time!

Right on the heels of the recent SQL Server 2012 virtual online launch event (as in virtually not there :-), a...

Another Interesting Sort

In October of 2011, I shared an example of a peculiar set of sort requirements.  Today, I am going to...

Another Interesting Sort

Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:

Creative Database Naming January 2, 2020...