ColumnStore index

  • Comments posted to this topic are about the item ColumnStore index

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • Easy question as I have followed a session about this topic ( with a marvellous speaker , Frédéric Pichaud ) at Issy-les-Moulineaux. All the answers were given and fully explained , it is why I had no problem with this question.

    When I read the 1st time this question, I have hesitated 2012 or 2014 and I remembered what Frédéric said :

    clustered ==> 2014

    nonclustered ==> 2012 and 2014

    After this little hesitation , all the choices were easy.

    Thanks.

  • Interesting, I just learned about them last two weeks.

    😀

  • This was removed by the editor as SPAM

  • Thank you for the post, really really good one. (I got it wrong as I never used it, have to learn about this)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Nice question, thanks.

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

  • I wasn't awake enough to realize the year. :doze: Thanks for the great question.



    Everything is awesome!

  • https://msdn.microsoft.com/en-us/library/gg492088.aspx

    says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. Grrr.

  • ssimmons 2102 (2/23/2015)


    https://msdn.microsoft.com/en-us/library/gg492088.aspx

    says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. Grrr.

    +1

  • I don't understand why the 'physically stored' options is not considered one of the right answers.

    What's the fine details here that I'm missing?

    A clustered columnstore index is regulating how the data is stored on the disk. Or are you making the distinction that sure, it places it in a special way on the disk, but it's not ordered - like a clustered index.

    ?

    missing something in Seattle.....

  • DataTherapist (2/23/2015)


    I don't understand why the 'physically stored' options is not considered one of the right answers.

    What's the fine details here that I'm missing?

    A clustered columnstore index is regulating how the data is stored on the disk. Or are you making the distinction that sure, it places it in a special way on the disk, but it's not ordered - like a clustered index.

    ?

    missing something in Seattle.....

    From BOL:

    Columnstore indexes are ordered according to the compression algorithms. Sorting would eliminate many of the performance benefits.

    In addition in the create syntax you cannot specify any column, so it's impossible to sort (on what?).

  • Columnstore indexes are ordered according to the compression algorithms. Sorting would eliminate many of the performance benefits.

    In addition in the create syntax you cannot specify any column, so it's impossible to sort (on what?).[/quote]

    Fair enough!

    thanks!

  • ssimmons 2102 (2/23/2015)


    https://msdn.microsoft.com/en-us/library/gg492088.aspx

    says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. Grrr.

    The question is specifically about clustered columnstore indexes, which were introduced in 2014. The referenced site does not contradict that nor does it state that a clustered columnstore index was introduced in 2012.

    Columnstore indexes were introduced in 2012, but that was only nonclustered types.

    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

  • SQLRNNR (2/23/2015)


    ssimmons 2102 (2/23/2015)


    https://msdn.microsoft.com/en-us/library/gg492088.aspx

    says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. Grrr.

    The question is specifically about clustered columnstore indexes, which were introduced in 2014. The referenced site does not contradict that nor does it state that a clustered columnstore index was introduced in 2012.

    Columnstore indexes were introduced in 2012, but that was only nonclustered types.

    Yep - that's the part I missed. Got the year part wrong.

  • I hope 1 day that my company will ever consider upgrading to SQL 2014 so our databases will get benefit from all the nice new performance features 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

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

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