Azure Synapse Analytics | Index Options | Columnstore Index | Best Practices

[@joseantoniolopezmesa6807]

This video series are so good that I am using them as reinforcement for dp-203 exam preparation. Thank you and keep up the great work.

[@amiyakumarnayak8286]

It's the most detailed and thorough explanation. Thank you

[@amittyagi9171]

I really admire the way you explained these concepts with demos included. Thank you.

[@auhumanmedium]

Thank You, Sir.... This is ULTIMATE

[@shaanproms2101]

Thank you for the video Arshad!

[@mayurkc]

Detailed and thorough explanation. Thank you for this series.

[@gudukumar748]

Content and explanation is really simple to understand...thank you sir jee. awesome to see you after long time.

[@SinghalPuneet]

Best explanation on topics.. makes each bit very clear and always goes from left to right instead of jumping to/fro.

[@VK-ln9vk]

wonderful video on indexes.Thank you so much sir

[@plearns4551]

Too good sir, pls keep going

[@deepakganesh1033]

Thank you very much for providing such a detailed information of Azure Sql Data Warehouse

[@ArshadAliAasTrailblazers]

You are most welcome

[@KathyLoisAmores]

Easy to follow. Thanks so much.

[@datoalavista581]

Thank you for sharing !!

[@rahamanabdul6388]

very well explained..Thank you so much for great videos..

[@ArshadAliAasTrailblazers]

Thanks Rahaman for your kind words, glad it was helpful!

[@sanjuaneselperu4755]

Great !! Your explanation was very good.
Now I have tables in the Synapse Pool that need statistics, a video recommending the correct execution of the statistics in tables would be very good.

[@Krishna-st4vp]

very well presented , thank you

[@ArshadAliAasTrailblazers]

You are welcome!

[@ateet82]

Thanks for taking out time and providing such a insightful details about indexing !!
Any thoughts at 40:00 - how can someone identify if particular rowgroup is softdeleted ? and why so 2 RowGroup/Distribution during ingestion & 1 RowGroup/Distribution during update ? is there any pattern or logic behind it ?

[@ArshadAliAasTrailblazers]

Thanks Ateet! A rowgroup with "Tombstone" state indicates all data is deleted. ua-cam.com/video/VasYevUAStk/v-deo.html

[@contactbhasker7483]

background music is very disturbing