Post reply

Columnstore Indexes

  • August 13, 2015 at 8:51 am

    #1819712

    Huge advancements in columnstore indexes in 2016. It looks pretty promising.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 13, 2015 at 12:37 pm

    #1819845

    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.

    If anyone thinks this question's answer is correct, they need English comprehension lessons!

    Tom

  • August 13, 2015 at 12:39 pm

    #1819847

    Steve Jones - SSC Editor (8/13/2015)

    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.

    Still wrong now, several hours after this post. I don't know what it said before, beut is can't have been any wronger than it is now.

    Tom

  • August 14, 2015 at 12:55 am

    #1819958

    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 here

  • August 14, 2015 at 6:46 am

    #1820027

    Steve Jones - SSC Editor (8/13/2015)

    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.

    Ahh, thank you!

  • August 18, 2015 at 8:06 am

    #1820749

    Ed Wagner (8/13/2015)

    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.

    Same with me.

Viewing 6 posts - 16 through 20 (of 20 total)

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