SQLPerformance.com

SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the "how" and the "why."

Articles by SQLPerformance.com

Following up on her post about automatic plan correction, Erin Stellato talks about a new feature in Azure SQL Database: Automatic Index Management.
Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance.
March 29, 2018 | SQLPerformance.com | Execution Plans, T-SQL 0
Paul White continues his series on row goals, treating a redundant and problematic TOP (1) that is added to the inner side of an apply anti join.
March 19, 2018 | SQLPerformance.com | Execution Plans 0
Usually DISTINCT and GROUP BY will yield the same results, but here Rob Farley explains cases that can break the rule.
March 13, 2018 | SQLPerformance.com | Execution Plans, T-SQL 0
Continuing his in-depth series on row goals, Paul White explains both why and how they can impact queries involving anti joins.
March 7, 2018 | SQLPerformance.com | Execution Plans 0
Glenn Berry explains how the Spectre/Meltdown issues (and their patches!) may affect SQL Server performance, and provides a handy list of mitigation steps to keep your servers protected.
March 1, 2018 | SQLPerformance.com | Performance 0
Continuing his series on row goals, Paul White explains how they can impact certain types of semi joins, and how you can spot these effects in showplan and trace flag output.
February 22, 2018 | SQLPerformance.com | Execution Plans 0
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
Tim Radney gives an overview of Managed Instances, and explains how they bridge the gap between on-premises SQL Server and Azure SQL Database.
Glenn Berry explains several manageability and performance improvements relevant to those of you running SQL Server 2012 and SQL Server 2014.
January 2, 2018 | SQLPerformance.com | Performance 0
Jonathan Kehayias explains why, among other reasons, the impact on execution plans can make index fragmentation something you should care about.
December 18, 2017 | SQLPerformance.com | Performance, Fragmentation 0
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database - what they get you, and how much they cost.
Erin Stellato shows how to use Query Store to troubleshoot wait statistics in SQL Server 2017 and Azure SQL Database.
November 27, 2017 | SQLPerformance.com | Query Store, Wait Stats 0

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