patternsqlMinor
What is the minimum required compatibility level to use parallel SELECT INTO?
Viewed 0 times
thewhatcompatibilitylevelintominimumparallelselectuserequired
Problem
What is the minimum required compatibility level to use parallel
SELECT INTO in SQL Server 2014?Solution
In SQL Server 2014 parallel DML for the
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.
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.
Context
StackExchange Database Administrators Q#77201, answer score: 4
Revisions (0)
No revisions yet.