This is an article on tuning stored procedures.
This is something that I have been partly sucesfully doing over the last few weeks.
It is an art – you have to guess and test most of the time.
Stored Procedure Tuning Tips
Random outpourings of a software developer
Developer Rants 