Can anyone please list all the possible uses of the tempdb. I know if you create temp tables it writes to the tempdb. I have a tempdb that everynow and then increases to 10GB in one day, but we don't know why. Any ideas? Thanks
http://sqlserver-qa.net/blogs/perftune/archive/2007/08/14/1415.aspx https://msmvps.com/blogs/ssqa/archive/tags/tempdb/sql server/default.aspx