Thank you very much. Clever!

Thanks, I tried that first but doesn't work because the group by takes the unique season code, therefore the MIN and MAX aggregates don't take into account season codes that...

With 2012 you have to drop the columnstore index each time, then rebuild if inserting new records and only use nonclustered columnstore. I believe with SQL 2014 you can...

Hi,

I enjoyed your article.

Quick typo spotted - page 3 title should be titled "Gender" not "Designation" in the columnstore page examples.