Columnstore Indexes

Question

Columnstore Indexes

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
August 12, 2015 at 9:37 pm

#319828

Comments posted to this topic are about the item Columnstore Indexes
August 13, 2015 at 12:39 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

OK, I didn't select the option with the in-memory table, because the sentence ends with only.

This made me believe the answer suggested that you could only create columnstore indexes on in-memory tables, which is of course not true.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

helenlu7 65408 SSC-Addicted Points: 426 More actions · Answer 2

A columnstore index can be for disk-based tables as well, not just for in-memory table ONLY.

MCSE Data Platform; BI
MCITP Database Developer; BI

NicHopper SSCrazy Eights Points: 9090 More actions · Answer 3

helenlu7 65408 (8/13/2015)
A columnstore index can be for disk-based tables as well, not just for in-memory table ONLY.

Exactly, I thought the wording was a misleading here, as it can be created on both, not only in-memory tables.

Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

KitKaterina Ten Centuries Points: 1122 More actions · Answer 4

Koen Verbeeck (8/13/2015)
OK, I didn't select the option with the in-memory table, because the sentence ends with only.
This made me believe the answer suggested that you could only create columnstore indexes on in-memory tables, which is of course not true.

+1

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 5

Koen Verbeeck (8/13/2015)
OK, I didn't select the option with the in-memory table, because the sentence ends with only.
This made me believe the answer suggested that you could only create columnstore indexes on in-memory tables, which is of course not true.

Same for me.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

I had to research the answer because I haven't gotten to work with 2016 yet. I always enjoy starting my day by learning something new, so thank you.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

BrainDonor SSCoach Points: 19254 More actions · Answer 7

Same here - it could have been phrased better.

Steve Hall
Linkedin
Blog Site

Heals SSCrazy Points: 2234 More actions · Answer 8

Koen Verbeeck (8/13/2015)
OK, I didn't select the option with the in-memory table, because the sentence ends with only.
This made me believe the answer suggested that you could only create columnstore indexes on in-memory tables, which is of course not true.

Yep - same here. Not used 2016 yet so had to look them up on BoL, was quite suprised when I got it wrong hehe.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 9

Koen Verbeeck (8/13/2015)
OK, I didn't select the option with the in-memory table, because the sentence ends with only.
This made me believe the answer suggested that you could only create columnstore indexes on in-memory tables, which is of course not true.

I guess this was caused by a copy-paste-edit error as the word "only" was also present on the previous answers.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Heals SSCrazy Points: 2234 More actions · Answer 10

Luis Cazares (8/13/2015)
Koen Verbeeck (8/13/2015)
OK, I didn't select the option with the in-memory table, because the sentence ends with only.
This made me believe the answer suggested that you could only create columnstore indexes on in-memory tables, which is of course not true.
I guess this was caused by a copy-paste-edit error as the word "only" was also present on the previous answers.

Most likely. Still learned something though which is the point of these (Although by the time I use 2016 I'll probably need to look it up again :-D)

david.gugg SSCertifiable Points: 6102 More actions · Answer 11

Koen Verbeeck (8/13/2015)
OK, I didn't select the option with the in-memory table, because the sentence ends with only.
This made me believe the answer suggested that you could only create columnstore indexes on in-memory tables, which is of course not true.

Ditto.

Be still, and know that I am God - Psalm 46:10

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 12

Koen Verbeeck (8/13/2015)
OK, I didn't select the option with the in-memory table, because the sentence ends with only.
This made me believe the answer suggested that you could only create columnstore indexes on in-memory tables, which is of course not true.

+1. Still, had to look it up to make sure I understood all the restrictions, so not so bad at the end of the day. 🙂

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 13

Apologies, my grammar miscue. I had thought the "only" in the other two answers would lean towards the reading being only the answers given and not others. As opposed to only in memory and not on disk.

Changed the AND to OR. Awarding back points.