THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
cost threshold for parallelism
maximum degree of parallelism
SQL Server 2005
SQL Server 2008
SQL Server 2012
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 ...
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 ...
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 ...
March 21, 2009
Brought to you by