• Another one which states when server is ready to rock 'n roll

    USE master;

    SELECT login_time FROM sysprocesses

    WHERE spid = 1

    This return comes later then tempdb creation because in between a lots of DBCC checks and rollbacks/forwards are being performed before server is up and running.

    No big deal, we are talking seconds most of the time depending on sizes and other trivial stuff 😉