Monthly Archives: March 2012

Troubleshooting “A severe error occurred on the current command.”

I thought it might be useful to start a semi-regular series of entries on troubleshooting for the SQL Server developer. Google has come to my rescue lo, these many times: this is my way of returning the favor. For this first entry I thought I’d tackle one of the more mysterious-looking runtime errors I see  Read more »

March 21, 2012 Posted by: 6 Comments - Permalink

Speaking at SQLSaturday #111 in Atlanta on April 14

A month from today on April 14, 2012 I’ll be speaking at SQLSaturday #111 in Atlanta, GA (or, more precisely, in Alpharetta, GA).  This will be my first trip to Georgia and I’m delighted to be able to present alongside some of the biggest names in the SQL Server community.  It’s a great honor to be  Read more »

March 14, 2012 Posted by: Leave a comment - Permalink

Submit to speak at SQLSaturday Houston by March 15

SQLSaturday #107 in Houston is coming up on April 21, 2012.  The list of submitted sessions so far is fantastic, but ultimately incomplete if you have not yet added yours to the mix.  The deadline for Houston is a week from today on March 15, so don’t delay! SQLSaturdays are a great first time speaking  Read more »

March 8, 2012 Posted by: Leave a comment - Permalink

Using Excel to parse Set Statistics IO output

When tuning T-SQL, “set statistics io on” is definitely your friend. However, I know I cannot be the only developer whose eyes glaze over when I flip over to the Messages tab in SSMS and am greeted with this: That 58-line monstrosity is brought to us by our friend sp_help. Scanning through all that output  Read more »

March 7, 2012 Posted by: 12 Comments - Permalink