Index Tuning - Page Splits & Fragmentation (by Amit Bansal)

Подписаться 19 тыс.

Просмотров 15 тыс.

50% 1

Looking for comprehensive, deep-dive training on SQL Server Performance Tuning? Explore SQLMaestros All-In-One Performance Tuning Bundle. Five courses at a highly discounted price. sqlmaestros.com/all-in-one-bu...
The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world.
If you are a fan of live classes, you can explore the SQL Server Performance Tuning Master Class. 40 hours of deep-dive LIVE training. Attend LIVE & get the class recordings for a lifetime. sqlmaestros.com/sql-server-wo...

Наука

Опубликовано:

2 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 17

@shoaibahmed5039 4 года назад

Highly appreciate the way you teach fragmentation and what causes fragmentation. Everything including Demo & theory is tremendous.

@safkaify7875 Год назад

Good video with good explanations with simple examples. Please keep up the good work.

@jagjeetrathore1024 4 года назад

great , every time I watch your video, you not only covers theory but also practical...…….amazing

@AI-Health-posts 4 года назад

Many thank AB for the video..........it was very helpful understanding the concept.

@sachinjjawalkar 4 года назад

Super explanation ,Thank you for giving your time to share your knowledge with us

@anasshaikh9332 Год назад

thank you. was very helpful

@sindujamariyappan9324 4 года назад

Amazing content Sir. Very well explained

@patisol6 7 месяцев назад

Good video, thank you!

@afzaalawan 3 года назад

Great explanation.. many thanks

@kishankannayya2540 3 года назад

really good explanation its really helpfull for me thanks for sharing your knowledge

@mjkhan368 4 года назад

Thank you sir...

@mdsamiulislam2522 2 года назад

Good Explanation

@varungupta2300 2 года назад

Thanks for the details. With cluster index expectation is data should be stored in order. Does it not hand in hand with pages?

@bluerays5384 Год назад

Gr888 Content Sir, lot of learning toady...Keep sharing... #bow

@sria21821 Год назад

Great 👍

@coding3438 Год назад

Once you have the clustered index created, you don’t have to mention order by cluster key. SQL server will always retrieve them in order regardless of the order by clause, right?