09 – Table Variables vs Temp Tables: The 2019 Rematch (10m)

You’ve heard that SQL Server 2019 got deferred compilation for table variables – so does that mean they’re as good as temp tables now, and we can use ’em without fear? Well, no – they still don’t have statistics, so the plans they produce still can’t compete with good ol’ temp tables. Demo script: Transact-SQL…

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