What is the minimum required compatibility level to use parallel SELECT INTO in SQL Server 2014?
Asked
Active
Viewed 305 times
5
ypercubeᵀᴹ
- 97,895
- 13
- 214
- 305
usr
- 7,330
- 5
- 32
- 58
1 Answers
4
In SQL Server 2014 parallel DML for the SELECT INTO statement requires compatibility level 120.
110:
A SELECT INTO statement always creates a single-threaded insert operation.
120:
A SELECT INTO statement can create a parallel insert operation. When inserting a large numbers of rows, the parallel operation can improve performance.
Note, that other resources on the web state false values for the compatibility levels. These statements are quoted directly from Microsoft documentation and have been verified experimentally by me.
usr
- 7,330
- 5
- 32
- 58