Category: Query Plan Analysis

Paul White provides some great information about row goals, explaining why they're important to understand when examining why the query optimizer made a certain choice.
Adaptive Query Processing in SQL Server 2017.
Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries...
Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL.
Kevin Kline provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of SQL Server trace flags.
Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.
Learn more about all of the newest features added to SSMS from Kevin Kline's latest article on DBTA.
For this month's T-SQL Tuesday, Rob Farley looks at some unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.
Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
Aaron Bertrand explores yet another scenario where a date/time...
Paul White shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.
Aaron Bertrand provides some insight into a new feature in SQL Sentry v10, and coming soon to Plan Explorer: Index Analysis.
Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
Aaron Bertrand describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.
Jason Hall shows off some of the new features in a brand new update for Plan Explorer.

Top Categories

See all
1 2 3

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More