• Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

  • May 20 2024
  • Length: 1 hr and 5 mins
  • Podcast

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques By cover art

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

Listen for free

View show details

  • Summary

  • Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath)

    Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality estimator, Table Variables, Automatic Plan Correction, Batch Mode, index rebuilds, Hekaton, NOLOCK, page compression, partitioning, filtered indexes, columnstore, join hints, PSPO, indexed hints, indexed views, optimize for unknown, RCSI, adding more memory, restarting the damn thing, scalar UDFs, and Persisted Memory Grant Feedback.
    Show more Show less
Politics & Government
Show more Show less

What listeners say about Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

Average customer ratings

Reviews - Please select the tabs below to change the source of reviews.

Audible.com reviews

Amazon reviews
No Reviews are Available