ZARZA We are Zarza, the prestigious firm behind major projects in information technology.
Listen "Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques"
Episode Synopsis
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.
More episodes of the podcast Dear SQL DBA
Jer and Kendar Explore Optimized Locking
04/09/2023
Erik Darling on Performance Tuning
21/08/2023
Data Roles: DBA, DBRE, and Data Engineer
04/08/2023
Down Tools Week 2020
05/08/2020
In God we trust