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 explains the importance of hardware choices for SQL Server running on your own hardware vs. Azure Virtual Machines.
November 6, 2017 | SQLPerformance.com | Azure, Virtualization 0
Erin Stellato lists out all of the enhancements to statistics in SQL Server over the years, from SQL Server 7.0 all the way through to SQL Server 2017.
October 23, 2017 | SQLPerformance.com | Statistics 0
Rob Farley gives a rather thorough crash course on PowerShell for this month's installment of T-SQL Tuesday.
September 12, 2017 | SQLPerformance.com | T-SQL Tuesday 0
Paul White : Trigram Wildcard Search in SQL Server
September 8, 2017 | SQLPerformance.com | Execution Plans, T-SQL 0
Glenn Berry talks about some upcoming AMD processors, which he says may change the server processor landscape.
Andy Mallon walks through identifying and fixing a serious performance issue with a multi-statement table-valued function in Dynamics CRM.
August 22, 2017 | SQLPerformance.com | T-SQL 0
Paul White whips out the debugger while showing how SQL Server derives estimates when combining multiple, single-column statistics.
August 2, 2017 | SQLPerformance.com | Statistics 0
Glenn Berry of SQLskills walks through the next iteration of Intel Xeon processors, and how they suit SQL Server 2017.
Michael Swart (@MJSwart) shows how to investigate and fix database connection leaks, an application issue that can lead to connection timeouts.
July 7, 2017 | SQLPerformance.com | SQL Server 0
Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.
June 30, 2017 | SQLPerformance.com | In-Memory OLTP 0
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
Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.
June 2, 2017 | SQLPerformance.com | Azure 0
Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries...
Jonathan Kehayias of SQLskills discusses SQL Server on VMware, and how to monitor CPU performance - with or without access to vCenter.
Paul Randal explains how the SQLskills Wait Types Library uses anonymous data from SentryOne to indicate whether a wait type is...

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