Batch Mode Hacks in SQL Server (Dear SQL DBA Episode 42)

Learn what batch mode is in SQL Server, and how you can trick SQL Server into using it (even without a “real” columnstore index).

This week the video, explanation, links, and demo code are all over at  The content just ended up being useful enough that I wanted to be able to link to it locally there from my query tuning courses.

Happy hacking!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.