Adaptive Joins and Memory Grants in SQL Server
Adaptive joins let the optimizer choose between a Hash Join and a Nested Loop join at runtime, which can be fantastic for performance when row count …
Read MoreDear SQL DBA - Performance Tuning with Erik Darling
Category:
query-performance
, sql-server
SQL Server performance tuning expert Erik Darling joins the podcast today to chat about how good queries can go bad and how bad queries can get better.
He also answers the question on everyone’s mind: if he was a database, what database would he be?
My Chat With Erik Darling
Good Stuff From Erik
More Dear SQL DBA
Check out the episode index.
RELATED POSTS
