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 » internals » Temporary Tables   (RSS)
  • 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 Page Free Space (Weblog) by Paul White on August 16, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement