top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is maxdop in sql server

+6 votes
301 views
What is maxdop in sql server
posted Nov 19, 2013 by Shweta Gupta

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+5 votes
 
Best answer

Maxdop is used to provide serialization to any SQL query. You can use it if you dont want parallelism in query, or if you are facing dead lock error somewhere than also you can use this to avoid deadlock.

answer Nov 19, 2013 by Neeraj Pandey
...