Different query optimizations and how you can use and tune them to get better performance.

Subquery Optimizations

Optimization Strategies

Optimizations for derived tables

Table Elimination

Other Query Optimizations Articles