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

[@abhay6276]

Sir you told us update statement causes fragmentation...last you ran update statement how did it executed fast.? Instead it increases fragmentation level...means whenever dml command execute the data stored on pages which are mis matching with logical order...please clear it 😊

[@safkaify7875]

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

[@shoaibahmed5039]

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

[@jagjeetrathore1024]

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

[@anasshaikh9332]

thank you. was very helpful

[@patisol6]

Good video, thank you!

[@Imrannaseem818]

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

[@sachinjjawalkar]

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

[@sindujamariyappan9324]

Amazing content Sir. Very well explained

[@kishankannayya2540]

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

[@mdsamiulislam2522]

Good Explanation

[@varungupta2300]

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

[@afzaalawan]

Great explanation.. many thanks

[@bluerays5384]

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

[@sria21821]

Great 👍

[@mjkhan368]

Thank you sir...

[@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?

[@abunaserbhuiyan1445]

Can I have the script...