Brent Ozar did a nice gesture in these difficult times and gave away part of his training course for free. So if you really need to spice up your SQL server skills, this is really the training for you.
Start with the āHow to Think Like the Engineā:
Then continue with the āFundamentals of Index tuningā:
- Indexing for the WHERE Clause
- Indexing for ORDER BY
- Indexing for JOINs
- Clippy's Index Recommendations
- Recap and Next Steps
And if you want to go even deeper, take it to the next level with āFundamentals of Query tuningā:
- Building a Query Plan
- How to Find the Right Queries to Tune
- How Parameters Influence Cached Plans
- Improving Cardinality Estimation Accuracy
- Common T-SQL Anti-Patterns
Thanks Brent for all the great (free) content!