sqlbuddy123 (3/11/2014)
curious_sqldba (3/11/2014)
Exactly, but my plan is using MAXDOP =0 ( 24 cores) in my case. Did you notice this?
Where did you find that ? I don't see any Parallelism operator in the plan.
--
SQLBuddy
If you hover your mouse to the insert statement you will see it is using DOP =0.