Category: Execution Plans (2)

Erin Stellato gives an overview of Automatic Plan Correction in SQL Server 2017 and Azure SQL Database, and assures us that Microsoft is not trying to code us out of jobs.
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.
Aaron Bertrand addresses the questions raised during two parameter sniffing webinars in January with Kimberly L. Tripp and Andy Mallon.
February 7, 2018 | SQLPerformance.com | Execution Plans, T-SQL 0
Paul White : Trigram Wildcard Search in SQL Server
September 8, 2017 | SQLPerformance.com | Execution Plans, T-SQL 0
Adaptive Query Processing in SQL Server 2017.
Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar column...
June 14, 2017 | SQLPerformance.com | Execution Plans 0
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.
Paul White (@SQL_Kiwi) takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries.
Greg Gonzalez uses Plan Explorer to walk through troubleshooting a very common type of deadlock: updates conflicting with key lookups.
In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.
Rob Farley uses this month's T-SQL Tuesday to show off the results of one of his Connect items: Estimated Number of Rows to be Read.
Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.
October 17, 2016 | SQLPerformance.com | Execution Plans, T-SQL 0
Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations.
September 27, 2016 | SQLPerformance.com | Execution Plans, T-SQL 0
SQL Sentry CEO Greg Gonzalez announces the completely free Plan Explorer 3.0, with two groundbreaking new features (Index Analysis and Performance Profiling).
September 8, 2016 | Greg Gonzalez | Execution Plans, Plan Explorer 32
Aaron Bertrand continues his #EntryLevel challenge, discussing DATEFROMPARTS() and similar functions introduced in SQL Server 2012.

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