Eirikur Eiriksson - Tuesday, November 21, 2017 10:16 AM

Jason A. Long - Tuesday, November 21, 2017 10:01 AM

Jeff Moden - Monday, November 20, 2017 11:38 PM

Jason A. Long - Monday, November 20, 2017 10:03 PM

The load order is far less interesting than the actual database names... "BlackArts01" & "NastyFast01..." 
It's kinda like using the Kama Sutra to demonstrate how the Dewey Decimal System works, to a 15 year old...

You'd like the BlackArts01 and NastyFast01 databases.  They contain the guts of databases used in presentations to demonstrate some really fast code.  One of them, for example, demonstrates a 5 aggregate system across 7 million row (1040 bytes per row) of a 7GB table and uses one of the aggregates as a divisor for the others to produce 4 different temporal percentage aggregates by month for 7 years with 4 other columns ranking by month, month of year, year, and grand total... in about 4 seconds.  Part of the ancillary learning in that presentation is how to truly use minimal logging to create the table with the clustered index already in place and it clearly demonstrates why you shouldn't necessarily delete "duplicate" indexes.  It also demonstrates the fallacy of relying on a Clustered Index for performance especially on wide tables.

BlackArts01 was the precon that Ed Wagner and I did for Pittsburgh back in 2016 and featured parts of NastyFast01.  It's also where I pointed out the extreme importance of the number "318" to every DBA in the world. 😉

I'll admit to being intrigued... 
Are you going to spill the beans on "318" or is it become the new "42"?

Golden ratio of 7.5714285714285714285714285714286😉
😎