SQLBits 2022

Fragmentation Explained in 20 Minutes

What do index rebuilds and defrags really do?

You're rebuilding and defragmenting your indexes every day - but what does that actually mean? And why are people still complaining about performance?

Feedback link https://sqlb.it/?7316

Speaker

Brent Ozar's previous sessions

The Ascending Key Problem - 2025

300-Level Guide to Career Internals: Planning Your Career - 2022

500-Level Guide to Career Internals: Building a Brand - 2022

Fragmentation Explained in 20 Minutes - 2022

The New Robots in SQL Server 2017, 2019, 2022, and Azure - 2022

Fundamentals of Stored Procedures - 2022

300-Level Guide to Career Internals: Planning Your Career - 2020

500-Level Guide to Career Internals: Building a Brand - 2020

Deadlocks: Lets Do One, Understand It, and Fix It - 2020

"But It Worked in Development!" 3 Hard Performance Problems - 2018

Headaches of Blocking, Locking, and Deadlocking - 2018

Easy Performance Tuning: an Intro to Wait Statistics - 2015

Cool Story, Bro: The DBAreactions Guide to SQL Server 2014 - 2015

How to Pick SQL Server Hardware - 2014

How the SQL Server Engine Thinks - 2014

Watch Brent Tune Queries - 2014

Virtualization and SAN Basics for DBAs - 2010

SQL Server Storage - 1,000GB Level - 2010

T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig - 2009

Using Perfmon and Profiler - 2009