Bonus – Memory Usage by Different Operators (15m)

When building query plans, SQL Server needs to come up with a memory grant number. In this demo, you’ll learn which operators require memory, how memory needs are estimated, how memory is shared in a query plan, and how parallel queries use memory. Demo script: Transact-SQL /* Memory Grants v1.1 – 2019-02-06 Here’s what you’re…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.