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

• Hugo Kornelis

  SSC Guru

  Points: 64790

  More actions

  January 4, 2017 at 12:00 am

  #317331

  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

  More actions

  January 4, 2017 at 8:32 am

  #1920649

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

  More actions

  January 5, 2017 at 8:45 am

  #1920899

  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