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!

Previous Post
SQLServer:Databases(_Total)\Transactions/sec vs SQL Statistics\Batch Requests/sec (video)
Next Post
Why I’m Inspired to Start Up Live Webcasts Again

Related Posts

No results found

Leave a Reply

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