jxhyao, I think the current recommendation is to set 'cost threshold for parallelism' to a higher value (default is 5) to discourage parallelism on relatively simple queries. Any stubborn...
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.
Get answers to questions, share tips, and engage with the SQL Server community in our Forums.
Sponsored Introduction Continue on to (or wait seconds) ×