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 1:44 am

    #1730911

    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.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden