Optimizing SQL queries for high concurrent workload
Tuning SQL queries for specific database platforms (Oracle, SQL Server, etc.)
How to minimize data movement in SQL queries
Using partitioning to improve SQL query performance
Understanding the impact of database statistics on SQL tuning