January 28, 2011 at 12:31 pm
what takes precedence, the OPTION(MAXDOP 0) hint or the server-wide configured valued?
--
Thiago Dantas
@DantHimself
January 28, 2011 at 1:10 pm
The hint when applied to a query will take precedence.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
January 28, 2011 at 1:12 pm
http://support.microsoft.com/kb/329204
---------------------------------------------------------------------
January 28, 2011 at 1:14 pm
Thanks
--
Thiago Dantas
@DantHimself
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply