SQL Rewriting Resources or tools

Hi,

What are some of the best resources for learning SQL rewriting for improving performance? Please let me know.

Secondly, what are some of free or paid browser based SQL rewriting or tuning tools which you don't need to install IF available. ( are there any available).

Regards!