Overview
Discover how to optimize SQL Server performance in this comprehensive conference talk from PASS Data Community Summit. Learn to identify and eliminate common anti-patterns and Row-By-Agonizing-Row (RBAR) operations that hinder database efficiency. Explore techniques to boost query performance on existing hardware, improve scalability for growing datasets, and optimize SQL Server in cloud environments with limited configuration control. Gain insights into schema and code design problems, focusing on real-world examples with reproducible workloads to demonstrate the impact of common mistakes and their quick fixes. Acquire practical skills to enhance SQL Server performance with minimal effort, making this session an essential resource for developers and database administrators seeking to maximize their database efficiency.
Syllabus
Eliminating Anti-Patterns and RBAR for Faster Performance - Jonathan Kehayias
Taught by
PASS Data Community Summit