Mixing OLTP and reporting using indexed views
I'm not a big fan of denormalizing, nor of repeating redundant redundant information in a database when those facts can already be derived from other information. A classic example of the latter is when...