Category: Execution Plans (3)

Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE..
Continuing the EntryLevel challenge, Aaron Bertrand discusses optimizing the kitchen sink procedure with dynamic SQL and, optionally, OPTION (RECOMPILE).
Aaron Bertrand shows that, at least for a large number of...
Aaron Bertrand follows up on a recent post about the performance...
Aaron Bertrand explores yet another scenario where a date/time...
Following up on an earlier post about metadata, Aaron Bertrand reveals a few more of his sources for discovering changes in SQL Server.
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 revisits whether or not ColumnStore can help pagination workloads.
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.
Paul White spends some time optimizing update queries in order to explore some SQL Server internals.
December 16, 2015 | SQLPerformance.com | Execution Plans 0
Aaron Bertrand highlights a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in...
December 8, 2015 | SQLPerformance.com | Execution Plans 0
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...
SQL Server MVP Matan Yungman shows ways to identify specific query bottlenecks while the query is running, mostly using native tools in SQL Server.

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