• GilaMonster - Monday, November 20, 2017 4:33 AM

    Jeff Moden - Sunday, November 19, 2017 9:42 AM

    SQL-DBA-01 - Friday, November 17, 2017 1:29 PM

    ZZartin - Friday, November 17, 2017 1:17 PM

    Why not?

    Do you know the sequence is like this?

    It's an interesting question that you ask, especially since the startup order is Master, Resource, Model, TempDB, and MSDB.  My question is, why is it important to you?

    TempDB starts up before Model. Very slightly before, but still before (discovered when I was writing article on reasons why SQL won't start), at least in 2012. Though, without traceflags and startup switches, tempDB is usually logged as starting up well after all of the user databases, probably because the startup process is in parallel, so it's not something you can easily see.

    Not according to the SQL Server log file on my box.

    --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)