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