Skip to content
Hallway
0:00 / 0:00

#sqlserver#guid#indexfragmentation

Black Arts Index Maintenance 1.2 - Guids vs. Fragmentation | Jeff Moden

GroupBy

6.7K subscribers • 1 video on Hallway

YouTube
  • Recommended by 3 people: 3 in engineering communities.
  • A classic. People kept recommending it from 2022 to 2025.
  • Presented by Jeff Moden
  • An opinion. It argues one side of a question engineers disagree on.

Advanced. Deep dive for people who know the field.

12K views4 years ago3 recommendations

Databases and dataSystems programmingDatabase internalsSQLPerformance and optimization

Jeff Moden challenges conventional wisdom about random GUIDs causing index fragmentation and critiques standard index maintenance practices in SQL Server.

Want to learn more about GroupBy’s Sponsors? Check them out below! SolarWinds: loom.ly/ljHr3eg Redgate: loom.ly/Q65t2z0 Data Masterminds: loom.ly/JgisLIw SSG: loom.ly/MotcEjE This is NOT your typical presentation on the fragmentation problems of Random GUIDs. No… Instead we’re going to DESTROY THE MYTH OF RANDOM GUID FRAGMENTATION AND LAY WASTE TO CURRENT “BEST PRACTICE” INDEX MAINTENANCE in the process. Download Session Materials here: drive.google.com/drive/folders/1bk1d78P4OiCAolfoIgcXd969f78Z…

Why it's here

3 people recommend this

What people say. Recommended for debunking myths around random GUID fragmentation and showing that they can perform better than sequential GUIDs.

u/bladezorin r/dotnet • Recommends

On “.NET 9 will natively support UUID v7 👏”

A lot of terrible advice in this thread regarding GUIDs, indexes, and fragmentation. Please watch this underrated video by Jeff Moden: link to this video The short of it is random guids are actually better at reducing page splits and fragmentation vs sequential guids. They also reduce hot spot issues that you get with using an identity. Do your own research but the "common knowledge" in this thread is based on conjecture not data.
10View on Reddit

u/kaki2308in r/dotnet • Recommends

On “SQL Server index design for multitenant database”

.net 9 can do UUID v7 which are more database friendly and also guids are not so terrible: Black Arts Index Maintenance 1.2 - Guids vs. Fragmentation | Jeff Moden
6View on Reddit

u/bladezorin r/dotnet • Recommends

On “.NET 9 will natively support UUID v7 👏”

A lot of terrible advice in this thread regarding GUIDs and indexes. Please watch this underrated video by Jeff Moden: link to this video
4View on Reddit

u/Jeff_Modenin r/dotnet • Recommends

On “When do you decide whether to use a GUID or an autoincrementing integer as your primary key?”

…ideo WILL change your mind about a whole lot of things including the 22 year old mistake known as "Best Practices" Index Maintenance, which are actually a WORST PRACTICE for just about anything you've lowered the Fill Factor for to try to get rid of fragmentation. Here's the link to the video. Watch it to the end for the 5.8 Million row proof. [video…
1View on Reddit