Index fragmentation in SQL Server: external and internal fragmentation

In this video, we will talk about how index fragmentation(external and internal) happens, how to check index fragmentation and performance impact of index fragmentation in SQL Server.

Furthermore, we will briefly talk about read ahead and clustered indexing in SQL Server.

Chapters:
0:00 - Introduction
0:30 - Clustered index (briefly)
1:36 - Read ahead, scatter-gather read
3:50 - How index fragmentation happens
6:10 - Index fragmentation types
6:55 - T-SQL to check fragmentation
7:50 - Performance impact of fragmentation
9:16 - Summary

T-SQL:
AND
ORDER BY page_count DESC;

Watch all my playlists here:

[brillianttourslk]

Thanks a lot great explanation I'm really confused about the difference between Physical order and Logical order?

[Toan.nguyen]

Could i ask your option about should or not shinking database when have alot of unsued space disk

[amarcse]

thanks mate for the beautiful session❤ ...I looked into the next video to learn about maintaining and resolving index fragmentation, but the relevant information was not available.

[abhay]

Bro your content of this video is awesome but your accent make me difficult to understand even though watching twice same result 😢😢😢