Home > IT Answers > SQL Server > maxdop hint
tcstl
90 pts.
 maxdop hint
MAXDOP, SQL, SQL Server
I have encountered the bug with MS and the processor issue with Mutlitple processors, the solution is to put the MAXDOP hint. SInce I have never used this and all the MS KB say to use it but not where and how, what is the proper syntax. ( I have a dual processor quad-core new dell)

Software/Hardware used:
ASKED: March 14, 2008  7:51 PM
UPDATED: March 14, 2008  8:17 PM
RELATED QUESTIONS
Answer Wiki:
The MAXDOP is used like this. <pre>SELECT * FROM TABLE WHERE Col1 = 'Value' OPTION (MAXDOP 1)</pre> Basically it should be the last line of the SELECT statement.
Last Wiki Answer Submitted:  March 14, 2008  8:08 pm  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,505 pts.