Just in case anyone is interested in the side bar of which order the databases are loaded in, here's a list of the database loads on the last startup of my laptop. Entries chronologically start ascending from the bottom.
The order for that box is master, mssqlsystemresource, model, and then msdb. A bunch of user databases are loaded, then TempDB (the highlighted line) and then more user databases. That's a 2008 Developer's Edition.
On my prod box, which is the 2016 Enterprise edition, they look like this (kept the same bottom up order so as not to confuse and didn't print all the interceding database names).
... bunch of user databases here...
...bunch of user databases here...
From the looks of it, master started and then just about everything else started up at the same second mark including all the system databases except TempDB and that started last but only 3 seconds later.
So my guess is that the numbering they used was as I said... they were numbered according to the order of their development rather than anything having to do with startup order or anything else that may be logical with the possible exception of the master database. I was actually a bit surprised on both machines to see master load before the mssqlsystemresource database but I'll leave that to someone that knows the internals.
--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)