When you can get batch mode operators, and an example of their power (14 minutes)

Batch mode operators can make a huge difference in your query -- even if you pulled data from a rowstore index!

Back to: Execution Plans: Partitioned Tables & Columnstore Indexes (1 hour 30 minutes) > Hacking Batch Mode for Rowstore