Microsoft Fabric: Execution Plans in Fabric Data Warehouse

We have Execution Plans in Microsoft Fabric Data Warehouse! More specifically support for Set ShowPlan XML ON. What does that mean? How do we get to see it, how can we use it, and how does this make SQL Server Management Studio , SSMS, more relevant than ever? Join Bradley Ball, aka @SQLBalls , and find out!

Chapters
00:00 Show Me the Execution Plans
00:55 Demo SET ShowPlan XML ON
01:28 Demo Make the XML a SQL Plan
02:02 Demo Examining the Execution Plan
03:23 Demo Estimated Execution Plan in SSMS
03:50 Demo Inner Join vs Left Join
04:34 Demo Nested Views vs Base Table Queries
05:42 Demo Nested Views vs Base Tables Complex Query
SET SHOWPLAN_XML (Transact-SQL)
https://studio.youtube.com/channel/UC0WSqYstuCm0f9QoO1wmZIA/videos/upload?d=ud&filter=%5B%5D&sort=%7B%22columnType%22%3A%22date%22%2C%22sortOrder%22%3A%22DESCENDING%22%7D
Microsoft Fabric January 2025 update
https://blog.fabric.microsoft.com/en-in/blog/microsoft-fabric-january-2025-update
/*******************
/CONNECT WITH US!!
/*******************

Tales from the Field
Blusky: talesfromthefield.bsky.social
Twitter/X: https://x.com/TalesftField
Linkedin: https://www.linkedin.com/company/100091910/

Bradley Ball
Blusky: sqlballs.bsky.social
Twitter/X: https://x.com/SQLBalls
Linkedin: https://www.linkedin.com/in/sqlballs/

Daniel Taylor
Blusky: dbabulldog.bsky.social
Twitter/X: https://x.com/dbabulldog
Linkedin: https://www.linkedin.com/in/danieltaylor3/

Bradley Schacht
Blusky: bradleyschacht.bsky.social
Twitter/X: https://x.com/BradleySchacht
LinkedIn: https://www.linkedin.com/in/bradleyschacht/

Neeraj Jhaveri
Blusky: neerajny.bsky.social
Twitter/X: https://x.com/neeraj_jhaveri
Linkedin: https://www.linkedin.com/in/neerajjhaveri/

Josh Luedeman
Blusky: joshluedeman.bsky.social
Twitter/X: https://x.com/joshluedeman
Linkedin: https://www.linkedin.com/in/joshluedeman/

Andrés Padilla
Blusky: nodestream.bsky.social
Twitter/X: https://x.com/nodestreamio
Linkedin: https://www.linkedin.com/in/andrespadillaandrade/

Видео Microsoft Fabric: Execution Plans in Fabric Data Warehouse канала Tales From The Field