Columnstore Indexes

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720887

    Comments posted to this topic are about the item Columnstore Indexes

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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: 425

    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

  • This was removed by the editor as SPAM

  • NicHopper

    SSCrazy Eights

    Points: 9034

    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.

  • KitKaterina

    Ten Centuries

    Points: 1062

    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

    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: 286985

    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.

  • BrainDonor

    SSCoach

    Points: 19234

    Same here - it could have been phrased better.

    Steve Hall
    Linkedin
    Blog Site

  • Heals

    SSCrazy

    Points: 2234

    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: 183637

    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

    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: 5696

    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.


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • Jacob Wilkins

    One Orange Chip

    Points: 27891

    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: 720887

    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.

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

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