curious_sqldba (11/12/2013)
GilaMonster (11/12/2013)
Nope. Not unless your bulk load is querying the table first. Stats do not get created or updated unless they are needed to generate an execution plan.So bulk inserts don't need a execution plan? i thought every query needs it
We are selecting from source and bulk-inserting to this table. Should we disable those options on source?
You are selecting from the source before the bulk insert, is there a concern that the stats will be out of date before the bulk insert? If not, then you shouldn't have to worry about turning those options off.