» Temporary Table...
» Undocumented (RSS)
Sorry, but there are no more tags available to filter with.
SQL Server 2005 onward caches temporary tables and table variables referenced in stored procedures for reuse, reducing contention on tempdb allocation structures and catalogue tables. A number of things can prevent this caching (none of which are allowed when working with table variables): Named constraints (bad idea anyway, since ...