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!