THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Undocumented » Internals » Temporary Tables   (RSS)
Sorry, but there are no more tags available to filter with.
  • Temporary Table Caching Explained

    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 ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on August 16, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement