Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Removing tempdb files RE: Removing tempdb files

  • March 16, 2019 at 10:37 am

    #2024695

    Steve Jones - SSC Editor - Friday, March 15, 2019 9:36 AM

    It's the best answer. Clearing the system of a workload is a separate task and a separate question.

    Heh... no it's not.  The "Best Answer" would be the one that includes the "clearing of the guns" because the code won't actually work on most production systems because of the current workload.  This is especially true since the title of the question is ...

    Removing tempdb files

    😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)