Stephanie Giovannini (7/15/2016)
This QOTD should have a disclaimer:This schema blatantly violates second normal form and is presented for demonstration purposes only. Do not use this schema as part of class-scheduling system. No actual databases were mangled in the production of this question.
(Was that bothering anyone else?)
Nope. It seemed pretty clear it was an example for the purpose of the question. Additionally, it is far from the terrible stuff i see in the wild as a consultant. It really is probably about 10x better design than most things I see out there.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events