Koen Verbeeck (3/16/2015)
Can only create nonclustered columnstore index in SQL Server 2012
This makes it seem like you could only create nonclustered columnstore indexes in SQL 2012, but not in 2014. At least how I interpret it 🙂
Anyway, I got it correct as only one single correct answer seemed a bit few.
SO, The answer is wrong!
"Can only create nonclustered columnstore index in SQL Server 2012" says CAN ONLY CREATE in SQL Server 2012, but can also be created in SQL Server 2014.
There is only one single correct answer!
+1. It is frustrating to try to learn a new topic, then discover you are "wrong" when you answered the question correctly.
It's amazing to read through questions day after day and read about the incredibly subtle (and often significant) differences in SQL functioning, then to have so many replies simply gloss over and accept an obvious mistake without a word.
But in the end, none of us is perfect and I did learn something.