Pop Quiz

Brent Ozar sent out a pop quiz which had me go through a range of emotions.

https://twitter.com/BrentO/status/872427294735958017

• Trust → Everyone knows Temp tables are stored in the TempDB.


• Surprise → Those Brackets.


• Fear → How can this work without those databases on my SQL SERVER?


• Anger → I should know this!


• Sadness → I have a lot to learn.


• Joy → I am learning something now.


• Disgust → If this is a quiz on my SQL Server, why would any of this work without those databases.

After going through all these emotions and reading some of the comments, I was finally at peace that the entire code block would execute.  If the Temp Tables are created in the TempDB no matter what database we are in, all the databases referenced should not have and impact, and we will only be looking at TempDB.