Whats the most important thing when performance tuning?
Paul Randal has a great survey this week. You have to
decide on the ONE thing that is important when performance tuning.
It would have been good to have a second question to ask what your job role
is. I would expect a correlation between job role and the answer.
I won't say what I decided, I was torn. I think indexing is essential as you
can index out of many poor written queries but then again application code is
also important. As they say "you can't polish a turd", but if you don't have
enough memory then your performance won't be great either.
So which will you choose