Insert

I’ve wrote about parallel insert in a older post. This is an update to it.

Starting with sql server 2014, the engine allowed parallelism of the SELECT …INTO newTable operations.

Starting with sql server 2016, the engine allowed parallelism of the INSERT … SELECT operations, but in some conditions :

• use of TABLOCK : INSERT table (TABLOCK) …SELECT
• compatibility level of db  = >= 130.

 

But , there some conditions that disable parallelism :

• presence of a clustered index or any additional non-clustered indexes
• IDENTITY column

See more here

 

 

S