An interesting find about Temp tables in SQL Server

I ran into a very interesting issue with temp tables recently, when working on a case. The issue description goes something like this. We have an application preparing some SQL statements, and sending them to the SQL Database engine for execution. However, the “issue” is easily reproducible in SQL Server Management studio. The first batch…

6

Troubleshooting tempdb growth due to Version Store usage

Troubleshooting tempdb growth due to Version Store usage   Recently I worked on an issue where the tempdb database version store cleanup was not occurring. I created a small repro to demonstrate the behavior. My tempdb has been showing the version store usage below for the past 3 days: sys.dm_db_file_space_used   runtime                         version_store_kb     2010-10-08 10:28:52.740…