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

Glenn Berry talks about the AMD EPYC CPUs now found in Azure Virtual Machines (in some regions) and their usage in balanced SQL Server workloads.
April 8, 2019 | SQLPerformance.com | Azure 0
Paul White explains why the IGNORE_DUP_KEY index option on a clustered index can result in much poorer performance than for a nonclustered unique index.
Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.
Tim Radney explains some of the nuances of performance tuning your workloads in Azure SQL Database and Azure SQL Database Managed Instance.
Itzik Ben-Gan starts a new blog series on T-SQL bugs, pitfalls, and best practices, leading off with some common issues involving determinism.
Erin Stellato walks through a quick and simple way to use Extended Events and the new XEvent Profiler to review queries on your system.
February 25, 2019 | SQLPerformance.com | Extended Events 0
Download the slide deck from Aaron Bertrand's latest presentation, "Fix Slow Queries. Fast."
February 21, 2019 | SQLPerformance.com | Plan Explorer, SentryOne 0
Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.
February 13, 2019 | SQLPerformance.com | T-SQL, closest match 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