Dr. Estera Kot

Performance best practices

Episode 74 of Fabric Espresso, the Microsoft Fabric video series created by Dr. Estera Kot.

Video thumbnail for Performance best practices. Opens the video on YouTube.

Length 17:24. Published Oct 16, 2024 on the Azure Synapse Analytics YouTube channel. Topic: Warehouse.

Watch on YouTube

About this episode

Text from the YouTube description.

Welcome back to another episode of Fabric Espresso DW series. In this episode, we'll be exploring the best practices for achieving optimal query performance when querying warehouse and lakehouse tables, as well as shortcuts.

🎙 Meet the Speaker:

👤 Host: Filip Popović is a Senior Product Manager at Microsoft and part of the Fabric Product Group, focusing on performance. Before joining Microsoft in 2019, he spent over ten years in the software and financial services industry, delivering business analytics solutions using the Microsoft technology stack.
LinkedIn: Filip Popovic | LinkedIn
Twitter: Filip Popovic (@FilipPop_MSFT) / X

👍 Like this video? Don't forget to hit the 'Like' button and share it with your network!

🔔 Stay Updated: For more insights into Microsoft Fabric Data Warehousing, and all things tech, make sure to subscribe to our channel and hit the notification bell so you never miss an episode!

#Microsoft #MicrosoftFabric #FabricWarehouse #queryperformance #tsql #performance #bestpractices

Chapters

  1. 0:00 Introduction
  2. 1:05 collocation
  3. 3:59 data model
  4. 8:32 table optimization
  5. 10:32 table partitioning
  6. 12:49 set ordering
  7. 14:49 Summary

All Fabric Espresso episodes