Grant Fritchey
Auteur de SQL Server Execution Plans
Œuvres de Grant Fritchey
SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance (2018) 4 exemplaires
Dissecting SQL Server Execution Plans 1 exemplaire
Étiqueté
Partage des connaissances
Il n’existe pas encore de données Common Knowledge pour cet auteur. Vous pouvez aider.
Membres
Critiques
Statistiques
- Œuvres
- 6
- Membres
- 43
- Popularité
- #352,016
- Évaluation
- 4.7
- Critiques
- 1
- ISBN
- 11
If you're new to understanding the execution plan concepts, I'd suggest you take the first two chapters slowly and thoroughly. I did this and it helped me to read through the plans myself and I only skimmed over the paragraphs to confirm my knowledge.
This book doesn't tell you how to write better queries directly, but by enabling you to understand how the optimizer works, you'll end up writing better queries yourself.
The book does take you down some real advanced topics like cursors and parallelism. I don't think I'll use those tips for the most part of my work, but it was great to know them nevertheless.… (plus d'informations)