Optimizing SQL queries with correlated subqueries
How to tune SQL queries that involve table-valued functions
Techniques for optimizing SQL queries involving UNION and MINUS operations
Optimizing SQL queries with multiple UNION or UNION ALL operations
Tuning SQL queries involving window functions