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