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.
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…]