SQL Server TempDB
How do I clear data from TempDB?

Answer Question   |  October 17, 2012  7:59 AM
SQL Server, TempDB

Tempdb Size increases and acquires the complete disk space
The issue goes as follows, Tempdb size generally remains around 3GB. One day it starts increasing and acquires the whole of the empty disk space of 29 GB within 15 hours. How can we avoid such kind of situations from happening in future? Any specific reason for such thing to happen? Also the .LDF file [...]

Answer Question   |  November 4, 2011  11:59 AM
Disk space, LDF file size, SIMPLE RECOVERY model, TempDB, Tempdb Size

Controlling tempdb Growth
I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of [...]

Answer Question   |  September 11, 2009  2:22 PM
SQL Server, SQL Server 2005, TempDB

Estimate SQL Server tempdb space for a query
Database – MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge – about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns [...]

Answer Question   |  August 3, 2009  7:46 PM
Space allocation, SQL Server, SQL Server Data Storage, TempDB

Where to place the tempdb log file?
I’ve heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?

Answer Question   |  April 13, 2009  6:11 PM
MDF, NDF, SQL Server, TempDB