Category: TempDb

• Temp Tables – Scoping & Eclipsing

  

  2012-10-16 - General, TempDb

  How long does a temp table live? Who can see and access it? What other types of temporary objects exist? What is a temp table Eclipse? This article will take an in-depth look at temporary objects and answer questions like the ones above.

  [more…]

• Deferred Deallocations of Pages in TempDb

  

  2012-02-19 - General, SQL Server Internals, TempDb

  The other day I ran into a question on msdn:Tempdb Deallocation (dm_db_session_space_usage). A person with the pseudonym DontPageMeBro noticed an odd behavior in his SQL Server installation: The sum of the reported usage of tempdb across all sessions was often [more…]