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 of SQLskills shows how sort operations can have a dramatic impact on plans, and what you can do about it.
Aaron Bertrand takes a closer look at some additional requirements for typically grouped concatenation queries in SQL Server.
August 20, 2014 | SQLPerformance.com | T-SQL 0
Glenn Berry of SQLskills demonstrates that the latest Azure VMs are a huge performance improvement over previously available hardware.
Glenn Berry (@GlennAlanBerry) of SQLskills continues his series on hardware selection, ou
Aaron Bertrand shows the safest and most efficient ways to perform grouped concatenation in SQL Server.
August 6, 2014 | SQLPerformance.com | T-SQL 0
Paul White details a regression bug in RCSI caused by a fix for a different bug. If you are running SQL Server 2008 R2, you should...
July 30, 2014 | SQLPerformance.com | 0
Erin Stellato of SQLskills compares the impact of adding additional index columns, by choosing
Paul White uses several examples to describe subquery cardinality estimate bug.
Erin Stellato of SQLskills shows how to use SQL Sentry Plan Explorer and SQL Sentry Performance Advisor to see automatic statistics updates.
Paul White continues his series on ACID and transaction isolation levels in SQL Server, giving us fair warning about some potential...
Continuing his series on knee-jerk reactions to wait statistics, Paul Randal (@PaulRandal) of SQLskil
Jonathan Kehayias of SQLskills discusses predicates in Extended Events.
June 19, 2014 | SQLPerformance.com | Extended Events 0
Aaron Bertrand of SQL Sentry takes a look at some unexpected behavior with CASE expression.
June 12, 2014 | SQLPerformance.com | T-SQL, SQL Server 0
Glenn Berry talks about the cost & performance aspects of the Azure virtual machines Microsoft is hoping you start adopting.

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More