Tweaking SQL Server Queries To Induce Parallel Execution Plans

Become a member! / @erikdarlingdata If you like what you see here, you'll love my advanced performance tuning training:
training.erikd... Click here for 50% off a health check: training.erikd...

[@hplarock8826]

Heard you are gonna be in NY for the redgate thingy...very tempted to go.

[@ErikDarlingData]

Well, I live in NYC, so I think that’s why they invited me. Let me know if you are going!

[@mortezasafaee6981]

Tnx bro...

[@ErikDarlingData]

No, thank you bro.

[@douglascoats7081]

Cool dude bro, job.

[@ErikDarlingData]

Thank you bro man.

[@FlaggedStar]

Iztik Ben-Gann has a good trick for this. He calls it the "parallel apply trick".

[@ErikDarlingData]

It’s not a bad idea, but the issue with parallel apply patterns is often that costing gets in the way. Only the outer side of nested loops is considered to benefit from parallelism, because the inner side is DOP copies of the plan running rather than the usual divide and conquer strategy. I have a video planned about it, but it’s an incredibly dense and difficult topic with many caveats and exceptions.