Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Non Temp Temp Tables RE: Non Temp Temp Tables

  • July 21, 2014 at 5:26 am

    #1730958

    ChrisM@Work (7/21/2014)

    Sreepathi1987 (7/21/2014)

    Easy One. 🙂

    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.

    Now the question becomes useful for me. Thanks..