Hi - I found out that you can write to the tempdb - but even if you have a tempdb of 5GB and only 2MB is used then the tempdb might grow when you write to it because the OS will not control where in the tempdb you write - i.e. it may write at the end of the unallocated spcae and force the tempdb to grow even if it doesn't need to. How can this be controlled to prevent the tempdb from gorwing too quickly???
Keep the transactions in short and make sure complex calculations or processes in resource intensive queries are handled with implicit temp tables creation, don't leave everything to system. YOu cannot avoid the query or process to avoid TEMPBD it is by default used since 2005 version. http://sqlserver-qa.net/blogs/perftune/archive/2007/08/14/1415.aspx on tempdb usage and https://msmvps.com/blogs/ssqa/archive/tags/tempdb/sql server/default.aspx relevant blog posts.
Implicit tables are created in tempdb by SQL server for storing the data intermediately from complex or large queries.
