Stairway to Columnstore Indexes Level 11: Optimizing Queries For Batch Mode (Part 2)

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Comments posted to this topic are about the item Stairway to Columnstore Indexes Level 11: Optimizing Queries For Batch Mode (Part 2)


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    This is a well written article with a lot of meat to it. Even though we are still on 2008 and can't apply a column index I can learn a lot from this. The basic concepts still apply. Thanks.

  • Alan Burstein

    SSC Guru

    Points: 61039

    Fantastic article Hugo. I really love this stairway series - really great stuff.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 3 posts - 1 through 3 (of 3 total)

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