• SSCrazy,

    MAXDOP is MAX DEGREE OF PARALLELISM (http://msdn.microsoft.com/en-us/library/ms181007(v=sql.105).aspx)

    A parameter that says to use just the number of seted cores on the server for each query, 0 is no limit, and 4 is 4 cores.

    I created a new topic.

    http://www.sqlservercentral.com/Forums/Topic1368992-377-1.aspx