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.
1 2 3 4

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

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial