Good question, thanks Steve.
ChrisM@Work (7/21/2014) Sreepathi1987 (7/21/2014)
But i think it is rather unusual, tempdb is completely wiped out whenever the SQL Server service restarts. Yes or No?
Yes, which makes tempdb useful as an experimental sandbox. If you forget to clear up your tables, SQL Server will do it for you.
Only when SQL Server next restarts, however. It is, therefore , possible to fill tempdb with experiments if it is not restarted in good time...
Space, the final frontier? not any more...
All limits henceforth are self-imposed.“libera tute vulgaris ex”