Home Forums SQL Server 2012 SQL Server 2012 - T-SQL parallel execution of CTAS statements RE: parallel execution of CTAS statements
Phil Parkin
SSC Guru
Points: 247210
More actions
February 9, 2016 at 9:56 am
#1857443
etl2016 (2/9/2016)hi, CTAS is create table as SELECTthank you
etl2016 (2/9/2016)
thank you
The simplest way I can think of doing this is using an SSIS package to submit the queries in parallel via multiple ExecuteSQL tasks.