In his Tales from the Field webcast, Bradley Ball presents the new execution plan capability in Fabric Data Warehouse, introduced in February's update. Ball demonstrates how to use "SET ShowPlan XML ON" and convert the XML output to a readable format by saving it with a .sqlplan extension in SQL Server Management Studio. Ball examines various execution plans to identify inefficiencies, mentioning a conversation with "Brad Chad" from the DW team about join operations. He shows how nested views dramatically increase query complexity and resource consumption compared to direct base table queries. In one example, he reduces the subtree cost from 10.8 to 0.3 by eliminating nested views, and in another complex query from 9.9 to 0.2. Ball emphasizes that execution plans help optimize queries by identifying performance bottlenecks, recommending correlation with DMVs to understand exact costs for Fabric instances, and describes this feature as "a massive step forward" for query optimization. Catch the full recording on YouTube: Microsoft Fabric: Execution Plans in Fabric Data Warehouse | buff.ly/4inErVT by Tales From The Field Show

Could you send me a .sqlplan copy of that plan, if you still have it? (You have my mail address, right?)

Yeah, it's just the explain. My/Our plan - the VS Code Extension comes online soon, and our devs that built this for SQLDev Web, will pivot that. And..make it avail for plans pulled from V$SQLPLAN and AutoTrace runs. BTW, we're looking for feedback on the displays!

At our MOUG/COUG conference, @malcherm leading the developer track with: SQL Plan Management @oracleugs @oracleace @ViscosityNA @cougorg #oracle #sqlplan #oracleindustrylab

Hidden secrets of #SQLServer Foreign Keys with @esaterkec #SQLPerformance SQLPlan sqlshack.com/hidden-secrets-…

Understanding Execution Plans of the #SQLServer Insert statement with @esaterkec #SQLPerformance #SQLPlan sqlshack.com/understanding-e…

How to read an execution plan with all details with @esaterkec #SQLPlan #SQLPerformance sqlshack.com/how-to-read-an-…

Explore the secrets of #SQLServer execution plans with @esaterkec #SQLPerformance #SQLPlan sqlshack.com/explore-the-sec…

A case study of SQL Query tuning in #SQLServer with @esaterkec #SQLPerformance #SQLPlan sqlshack.com/a-case-study-of…

Yes, please! (Or the .sqlplan file if you are at liberty to share)

New icon for .sqlplan?

SQL SUBSTRING function and its performance tips with @esaterkec #SQLPerformance #SQLPlan #TSQL sqlshack.com/sql-substring-f…

Dirty Reads and the Read Uncommitted Isolation Level with @esaterkec #SQLServer #SQLPerformance #SQLPlan sqlshack.com/dirty-reads-and…

Interpreting execution plans of #TSQL queries with @esaterkec #SQLPerformance #SQLPlan sqlshack.com/interpreting-ex…

The basics of Parallel Execution Plans in #SQLServer with @esaterkec #SQLPlan sqlshack.com/the-basics-of-p…

View Execution Plans in #AzureDataStudio with @rajendragupta16 #SQLPerformance #SQLPlan sqlshack.com/view-execution-…

Execution Plans in #SQLServer with @avikoleum #SQLPerformance #SQLPlan #SSMS sqlshack.com/execution-plans…

SQL AVG() function introduction and examples with @esaterkec #SQLPerformance #SQLPlan #TSQL sqlshack.com/sql-avg-functio…

ApexSQL Plan 2019 – Product update alert #SQLPlan #SQLPerformance #Free blog.apexsql.com/apexsql-pla…

ApexSQL Plan 2018 R9 – Product update alert #SQLPlan #SQLPerformance #Free blog.apexsql.com/apexsql-pla…