• MAXDOP is an option with which you can control the Maximum Degree of Parallelism. Details on the query hint is here

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga