Dirty Work
There are three classes of administrator when it comes to parallelism settings
- Never changed the defaults
- Changed the defaults to something wacky
- Changed the defaults to something safe
The beginning of this post is for the first couple …
Category: Parallelism
Software Vendor Mistakes With SQL Server: Not Getting Parallel Inserts Into #Temp Tables
Do That, But Faster
Serial zones in parallel plans can leave a lot of performance on the table. One of the best ways to see that is with insert queries that do a lot of work. A big contrast …
An Undocumented Restriction For Parallel Inserts In SQL Server That Can Kill Performance
Insert Card
I’d like to start this post off by thanking my co-blogger Joe Obbish for being lazy and not blogging about this when he first ran into it three years ago.
Now that we’re through with pleasantries, let’s talk …
Wait Stats During Exchange Spills In SQL Server Parallel Query Plans
Inorganic
Lots of people say these are rare — and perhaps they are becoming more so — but I still see them with some frequency. That’s not a terribly strong indictment of SQL Server, but that’s not the point of …
How Many Threads Can One Query Use In SQL Server?
Overlook
Something that many people overlook about parallel plans is that while they are limited to DOP active CPUs, they can suck up way more threads.
How many more depends on how many branches can be active at the same …
Common Table Expressions Are Useful For Rewriting Scalar Functions In SQL Server
Punching
Thanks for watching!
Going Further
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. I’m …
Table Partitioning And Parallelism In SQL Server Standard Edition
Jammed, Not Jellied
UPDATE 2021-04-14: Microsoft has updated the documentation for all 2016+ versions of SQL Server to indicate that parallelism is available for partitioned tables in non-Enterprise versions.
There’s been a note in the documentation since SQL Server 2016 …
How Useful Is Column Store Indexing In SQL Server Standard Edition?
Speed Limit
When I’m blogging about performance tuning, most of it is from the perspective of Enterprise Edition. That’s where you need to be if you’re serious about getting SQL Server to go as fast as possible. Between the unrealistic …
Multiple Distinct Aggregates: Still Harm Performance Without Batch Mode In SQL Server
Growler
Well over 500 years ago, Paul White wrote an article about distinct aggregates. Considering how often I see it while working with clients, and that Microsoft created column store indexes and batch mode rather than allow for hash …
What’s Really Different About In-Memory Table Variables In SQL Server?
Kendra, Kendra, Kendra
My dear friend Kendra asked… Okay, look, I might have dreamed this. But I maybe dreamed that she asked what people’s Cost Threshold For Blogging™ is. Meaning, how many times do you have to get asked a …