• Andy Leonard (2/8/2010)


    Great editorial Grant!

    This reminded me of the demise of my checklist. I used to think database tuning was a matter of checking off items on my checklist, in order, as I made corrections. I believed this until some of my changes took a server to its knees.

    Investigation revealed the checklist wasn't the problem - my faith in it was the problem.

    I'd built the checklist from experience. I went back to that experience and instead documented the methodology I'd used to gather measurements and create tests. This methodology replaced my checklist.

    :{> Andy

    Now that sounds like a great presentation. When are you giving it?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning