September 6th, 2018
Table variable deferred compilation

I talk about the pros and cons of letting SQL Server wait to get a more accurate cardinality estimate from a table variable.