Category: Execution Plans (4)

Paul White discusses some things to know about INSTEAD OF triggers - from execution plans and worktables to a cardinality estimation...
Paul White (@SQL_Kiwi) finishes up his series on the performance of calculating a median with a thorough treatment of eliminating bad elements fro
August 6, 2015 | SQLPerformance.com | Execution Plans, T-SQL 0
Paul White takes one more look at medians, this time describing how a locking hint can help improve the performance of a pre-2012 solution.
Paul White follows up a great post on calculating medians with some information on how locking can affect query performance, often...
Paul White demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: median with a dynamic cursor.
Paul White rolls up his sleeves in his usual way, showing off the debugger several times while explaining the internals of SQL Server.
Aaron Bertrand gives detail about an important enhancement in the latest release of SQL Sentry Plan Explorer, v2.7: better anonymization.
Paul White follows up on his thorough breakdown of indexed view maintenance with the details of a bug that can render an indexed view bug.
Lori Edwards (@loriedwards) continues her series on SQL Server statistics, this time showing how even up-to-date statistics can yield inaccurate estimates.
Paul White provides a very thorough explanation and walk-through of the strategy SQL Server uses to maintain the data in indexed views.
March 26, 2015 | SQLPerformance.com | Execution Plans 0
Benjamin Nevarez gives a very early look at a feature coming soon to Azure SQL Database and SQL Server vNext: the Query Store.
Aaron Bertrand walks through several potential causes for different plans for identical servers.
Aaron Bertrand discusses a handful of reasons "identical" query...
November 20, 2014 | SQLPerformance.com | Execution Plans, T-SQL 0
Paul White demonstrates performance tuning a SQL Server execution plan as a whole, instead of honing in too narrowly on individual...
October 2, 2014 | SQLPerformance.com | Execution Plans, T-SQL 0
Paul White talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of...

Top Categories

See all
1 2 3 4 5

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