Learn T-SQL With Erik: Memory Grants Intro

In this video, I dive into the fascinating world of memory grants in SQL Server, providing a gentle introduction to their behavior and implications. Starting with a humorous look at my current state due to the hot weather, I use practical examples to illustrate how memory grants work, especially within query plans that include sorts and hash joins. I also highlight the impact of string columns on memory grants, explaining why they can be particularly problematic for performance. The video is part of a series where we'll explore more advanced topics related to memory grants in future episodes. If you find this content valuable, don't forget to like, subscribe, and share it with your fellow SQL enthusiasts. CHAPTERS 00:00:00 - Introduction 00:03:44 - Memory Grants Overview 00:06:04 - Memory Grant Sharing 00:07:39 - String Columns and Memory Grants 00:10:23 - DOP and Memory Grants