Great article.  Thank you for information.

Question:  How does this compare performance wise with using Table-Value Functions for joins?

Go to first switch flip it. Leave room. Go to lightbulb rooms open all the doors but not enter.  See with one is on.  Go back and turn on next...