Batch Mode

I love Batch Mode and here is the list of the blog posts that I am writing on this topic:

Batch Mode – part 1 (“The Beginning”)
Batch Mode – part 2 (“Batch Mode on Rowstore in Basics”)
Batch Mode – part 3 (“Basic Heuristics and Analysis”)
Batch Mode – part 4 (“Some of the limitations”)
Batch Mode – part 5 (“TPC-H Queries”)

2 thoughts on “Batch Mode

  1. Basava Raju

    What are the vector processing(SIMD) operators used in SQL 2016. How does SQL optimizer deal with branch-miss, conditional execution, TLB misses and out of order execution when using InMemory Computing? Is there any tool to check this?

    1. Niko Neugebauer Post author

      Hi Raju,

      I would suggest using Intel’s Tune for this purpose.
      I believe that Microsoft sees no reason for providing any direct insight on those matters, since they can & are being changed regularly.

      Best regards,
      Niko Neugebauer

Leave a Reply

Your email address will not be published. Required fields are marked *