Remove sql-server-2016-parameter-sniffing
article thumbnail

Minimal Logging with INSERT…SELECT and Fast Load Context

SQL Performance

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. FastLoadContext can be disabled on SQL Server 2016 using documented trace flag 692. Fast Load Context.

Cache 64