Episode 123 - Beware of the Parallel Plan

Guy and Eitan take a break from talking about the PASS virtual summit, and celebrate with some interesting content.

Relevant links:

• Notes on the PASS Virtual Summit by Andy Warren:
  • Part 1
  • Part 2
  • Part 3
  • Part 4
  • Part 5
  • Part 6
  • Conclusions
• Satirical DBA Twitter accounts:
  • @TrumpDBA
  • @Bernie_DBA
  • @biden_dba
• Concatenating Strings in SQL Server | Guy Glantser
• Making a more reliable and flexible sp_MSforeachdb | Aaron Bertrand
• PrintMAX by Ben Dill
• PrintMaxMinified by Eitan Blumin
• Access Violation Error querying from system functions with parallelism
• SQL Server Cumulative Update releases are paused until end of December
• SQL Server TOP clause performance problem with parallelism | Neeraj Prasad Sharma
• What is MaxDOP controlling? | Pedro Lopes