How to optimize aggregate functions in SQL queries
Techniques for reducing disk I/O in SQL tuning
Dealing with table fragmentation in SQL tuning
How to effectively use indexes in SQL tuning
Importance of using appropriate data types in SQL tuning