THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » parallelism » MAXDOP   (RSS)
  • Connect Digest : 2012-01-09

    Hide databases from users who shouldn't be able to see them This is a long-standing request from Erland Sommarskog which I've highlighted in previous digests. But the underlying problem keeps coming up in multiple venues, so I thought it would be good to call attention to the item one more time. Some will argue that the contained database feature ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 9, 2012
  • SQL University: Parallelism Week - Part 3, Settings and Options

    Congratulations! You've made it back for the the third and final installment of Parallelism Week here at SQL University. So far we've covered the fundamentals of multitasking vs. parallel processing and delved into how parallel query plans actually work. Today we'll take a look at the settings and options that influence intra-query parallelism and ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 28, 2010
  • Six reasons you should be nervous about parallelism

    Don't get me wrong; parallel processing is great.  And with SQL Server in particular, there are many benefits to taking advantage of the power of multiple CPUs.  However, we have all had cases where what looked like parallelism was actually hurting us (you remember turning off hyperthreading on SQL Server boxes, right?), and cases where ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 21, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement