Skip to content
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques episode artwork

May 20, 2024 1 hr 4 min

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

from Dear SQL DBA Hosted by Kendra Little, Erik Darling

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.

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

0:00 1:04:36

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of Dear SQL DBA?

This episode is 1 hour and 4 minutes long.

When was this Dear SQL DBA episode published?

This episode was published on May 20, 2024.

Can I download this Dear SQL DBA episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.