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)
   / @tales-from-the-field  


Microsoft Fabric January 2025 update
https://blog.fabric.microsoft.com/en-...



/*******************
/CONNECT WITH US!!
/*******************

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

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

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

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

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

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

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