Browse by Tags

• Internals
• Procedures
• Query Plans
• Undocumented

• 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 Read More... Posted Friday, August 17, 2012 11:51 AM by Paul White | 9 Comments Filed under: Internals, Temporary Tables, Undocumented

• Temporary Tables in Stored Procedures

  Ask anyone what the primary advantage of temporary tables over table variables is, and the chances are they will say that temporary tables support statistics and table variables do not.  This is true, of course; even the indexes that enforce PRIMARY Read More... Posted Wednesday, August 15, 2012 5:22 AM by Paul White | 34 Comments Filed under: Procedures, Query Plans, Temporary Tables, Undocumented