![Dear SQL DBA artwork](https://is1-ssl.mzstatic.com/image/thumb/Podcasts113/v4/59/ab/d4/59abd4b9-e5da-2b36-9150-b2f2f8027ed0/mza_6525806208753554299.png/100x100bb.jpg)
Batch Mode Hacks in SQL Server
Dear SQL DBA
English - May 11, 2017 13:00 - 30 minutes - 57.1 MB - ★★★★★ - 27 ratingsTechnology Education How To dba databases sqlserver sqlworkbooks Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Previous Episode: Should I Get Certified as a DBA?
Next Episode: Removing Query Hints with Plan Guides
Learn what batch mode is in SQL Server, and how you can trick SQL Server into using it (even without a "real" columnstore index).
For clickable links and demo code, head to https://sqlworkbooks.com/2017/05/batch-mode-hacks-for-rowstore-queries-in-sql-server/