Category: Query Plan Analysis (2)

Jason Hall shows off some of the new features in a brand new update for Plan Explorer.
Paul White goes into detail about another reason you'll want to use the NOEXPAND hint, even when using Enterprise Edition.
The SQL Server plan cache is one of the most important architectural elements for DBAs to understand. Get the slide deck and sample scripts here.
Paul White discusses some less well-known query optimizer features and limitations, and explains poor performance of certain hash join...
Erin Stellato of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
SQL Server MVP Matan Yungman shows ways to identify specific query bottlenecks while the query is running, mostly using native tools in SQL Server.
Paul White discusses some things to know about INSTEAD OF triggers - from execution plans and worktables to a cardinality estimation...
Paul White follows up a great post on calculating medians with some information on how locking can affect query performance, often...
Paul White concludes his two-part series on SQL Server sort internals, including two new classes specific to In-Memory OLTP in SQL Server.
Paul White rolls up his sleeves in his usual way, showing off the debugger several times while explaining the internals of SQL Server.
Lori Edwards (@loriedwards) continues her series on SQL Server statistics, this time showing how even up-to-date statistics can yield inaccurate estimates.
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 posts the slide deck and links from his recent presentation on SQL Sentry Plan Explorer at SQL Saturday #357 in Cleveland.
There's a new query tuning book in town, this one from McGraw-Hill and written by Benjamin Nevarez. See what Aaron Bertrand thinks of this new title.
October 17, 2014 | SQLPerformance.com | Query Plan Analysis 0
Paul White uses several examples to describe subquery cardinality estimate bug.

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