Home Forums SQL Server 2012 SQL Server 2012 - T-SQL parallel execution of CTAS statements RE: parallel execution of CTAS statements

  • February 9, 2016 at 9:05 am

    #1857413

    etl2016 (2/9/2016)

    Hi,

    I have 10 CTAS statements creating temp tables. Once they are created, they are LEFT OUTER JOINED.

    Is there a way, a parallel execution of these 10 CTAS statements be enforced programmatically or does the Query optimiser engine take care of this automatically?

    thank you

    What are CTAS?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.