Loud Engine
If you’re ever on a long flight and want something to fall asleep to, ask a DBA how to set MAXDOP.
Sometimes I even ask myself that question when I’m tossing and turning at night.
There are a …
SQL Server Consulting, Education, and Training
If you’re ever on a long flight and want something to fall asleep to, ask a DBA how to set MAXDOP.
Sometimes I even ask myself that question when I’m tossing and turning at night.
There are a …
There are three classes of administrator when it comes to parallelism settings
The beginning of this post is for the first couple …
In yesterday’s post, I showed you the promo video and abstract for my SQLBits precon.
In today’s post, I’m gonna offer you a little bribery to show up.
First, all attendees will get one of these lovely T-Shirts. …
For SQL Server queries that require additional memory, grants are derived for serial plans. If a parallel plan is explored and chosen, memory will be divided evenly among threads.
Memory grant estimates are based on:
In dramatic fashion, I’m revisiting something from this post about stats updates.
It’s a quick post, because uh… Well. Pick a reason.
Follow along as I repeat all the steps in the linked post to:
Microsoft recently published new guidance on setting server level MAXDOP. I hope to help the community by analyzing the new guidance and offering some of my own thoughts on query parallelism.
Documentation is meant to be shared …
Thanks for watching!
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here…