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

Erin Stellato shows us how to use the Track Causality session option for more reliable performance troubleshooting with Extended Events.
Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.
December 27, 2018 | SQLPerformance.com | T-SQL, SQL Server, UDFs 0
Glenn Berry talks about a few of the security features in SQL Server 2017 and reminds us to always test and validate the performance impact.
December 17, 2018 | SQLPerformance.com | Security, SQL Server 2017 0
Itzik Ben-Gan starts a new multi-part series on solving a reader challenge involving joining between two tables based on closest match.
December 12, 2018 | SQLPerformance.com | T-SQL, closest match 0
Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.
Itzik Ben-Gan explains log buffer flushes and shows how to use them to help balance performance, transaction size, and durability.
November 14, 2018 | SQLPerformance.com | T-SQL, transaction log 0
Glenn Berry goes over three different tactics you can use to squeeze some extra performance out of SQL Server without a lot of heavy lifting.
Tim Radney talks about some of the things you can do to prepare for the end of extended support for SQL Server 2008 and SQL Server 2008 R2.
October 12, 2018 | SQLPerformance.com | SQL Server 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

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial