Index Tuning Essentials: Fixing Large Memory Grants Demo
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.
This is some great training. I tested your point about not putting the NVARCHAR(700) Text column to the NCI covering the window function. Still no memory usage on the query but it did decide to burn a lot of CPU on key lookups.
I’m really enjoying this series, thanks for putting it together!
Glad you’re enjoying it!