Query Tuning Essentials: How Table Variables Hurt SQL Server Query Performance
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.
It might be worth mentioning that if there could be many rows a TVP it can sometimes be worth the overhead to copy it into to a temp table (with TABLOCK, of course) and then using the temp table for joins instead of that TVP, for all the reasons you describe in the video.