anyone plan to write a blog about this? i had some findings about this
cost of threshold for parallelism and max dop will affect the query to turn batch mode into row mode
insert into table variable will turn batch mode into row mode
still in progress to find more causes.
Its all a bit Brand New for an old codger like me ... but I would like to learn more.
1 Like
The best series I've found on Columnstore is Niko's:
If the answer isn't in there, you can contact him with a specific question. If you're on Twitter, try the #sqlhelp hashtag too.
1 Like
niko blog is still in my reference since 3 months ago....but he/she is more toward what is columnstore but not batch(http://www.nikoport.com/batch-mode/ ).
additional findings
3. record <1m rows is forever in row mode.
partition elimination somehow eliminate batch mode as well.
Kristen
September 10, 2015, 10:39am
6
No idea if it adds anything but I stumbled over this relatively recent (28-Aug-2015) article on SQLMag
http://sqlmag.com/sql-server-2014/essential-guide-sql-server-2014-clustered-columnstore-index
1 Like