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

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

    -- Alan Burstein


    Helpful links:Best practices for getting help on SQLServerCentral -- Jeff ModenHow to Post Performance Problems -- Gail ShawNasty fast set-based string manipulation functions:For splitting strings try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL Server 2012+)To split strings based on patterns try PatternSplitCMNeed to clean or transform a string? try NGrams, PatExclude8K, PatReplace8K, DigitsOnlyEE, or Translate8KI 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