ColumnStore index

  • psingla

    Hall of Fame

    Points: 3840

    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/

  • patricklambin

    SSCrazy Eights

    Points: 9964

    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.

  • Carlo Romagnano

    SSC-Insane

    Points: 21984

    Interesting, I just learned about them last two weeks.

    😀

  • This was removed by the editor as SPAM

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    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.

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Nice question, thanks.

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

  • Dana Medley

    SSCertifiable

    Points: 6764

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



    Everything is awesome!

  • ssimmons 2102

    SSCommitted

    Points: 1634

    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.

  • RK Mandava

    SSCarpal Tunnel

    Points: 4153

    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

  • DataTherapist

    Mr or Mrs. 500

    Points: 510

    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.....

  • Carlo Romagnano

    SSC-Insane

    Points: 21984

    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?).

  • DataTherapist

    Mr or Mrs. 500

    Points: 510

    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!

  • SQLRNNR

    SSC Guru

    Points: 281243

    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

  • Ed Wagner

    SSC Guru

    Points: 286982

    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.

  • Hany Helmy

    SSChampion

    Points: 13488

    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 🙂

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

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