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.