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. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.
Related Posts
- Indexing SQL Server Queries For Performance: Unpredictable Searches
- Indexing SQL Server Queries For Performance: Equality and Inequality Predicates
- How To Write SQL Server Queries Correctly: Literally Everything You Need To Know About OUTPUT
- How To Write SQL Server Queries Correctly: Literally Everything You Need To Know About CTEs
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!