Unfortunately, there really isn't any sort of automated method for tuning queries. It's actually somewhat hard work requiring quite a bit of specialized knowledge. The two books down in the links in my signature are very good resources to get you started. If you have specific questions on a specific query, you can always post the query along with the execution plan here on SQL Server Central.