This post provides new information about the preconditions for minimally logged bulk load when using
INSERT...SELECTinto indexed tables.
The internal facility that enables these cases is called
FastLoadContext. It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. From SQL Server 2016 onward,
FastLoadContextis enabled by default; the trace flag is not required.
FastLoadContext, the only index inserts that can be minimally logged are those into an empty clustered index without secondary indexes, as covered in part two of this series. The minimal logging conditions for unindexed heap tables were covered in part one.
Click thorugh for a highly informative article.