In this video, you will understand the following concepts: SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Memory Clerk
You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code).
All DPG members (membership is free) have free access to many learning resources including in-person events, webinars, past event resources, videos, magazine & Hands-On-Labs.
If you wish to practice a SQL concept step-by-step, try SQLMaestros Hands-On-Labs. (Get access to hundreds of lab documents on SQL Server, Azure, Analytics, BI, Machine Learning, etc)
If you are looking for advanced SQL Server & MS Data Platform Training (in-person & online), explore SQLMaestros.