Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Eliminating Anti-Patterns and RBAR for Faster Performance

PASS Data Community Summit via YouTube

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

Reviews

Start your review of Eliminating Anti-Patterns and RBAR for Faster Performance

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.