Home Forums SQL Server 2008 T-SQL (SS2K8) Trying to generate a parallel execution plan RE: Trying to generate a parallel execution plan

  • March 5, 2015 at 4:00 pm

    #1782057

    jdbrown239 (3/5/2015)

    Thanks Alan

    What is the syntax for make_parallel() ?

    It's all in the article. Click on the differently colored "make_parallel" in Alan's post. It's a link to the article.

    As a bit of a sidebar, why do you think you need to force-parallel such a query?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)