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

Itzik Ben-Gan discusses the ins and outs of numbering and retrieving rows in a nondeterministic (but explicitly not random) order.
November 13, 2019 | SQLPerformance.com | SQL Server, SQL Server 2019 0
Aaron Bertrand shares his thoughts about the upcoming SQL Server 2019 release and, specifically, edition-specific features.
November 1, 2019 | SQLPerformance.com | SQL Server 2019 0
Erin Stellato shows how to analyze patterns in your workload when dealing with many short, resource-intensive queries.
October 29, 2019 | SQLPerformance.com | SQL Server 0
Jonathan Kehayias describes various ways you can suffer (and prevent) event loss when using Extended Events in SQL Server.
October 17, 2019 | SQLPerformance.com | Extended Events 0
Itzik Ben-Gan discusses lesser-known T-SQL features and some aspects that many of us make assumptions about.
October 10, 2019 | SQLPerformance.com | T-SQL 0
Paul White discusses performance spools, and how they can be used by the optimizer to reduce the estimated cost of nested loops joins.
September 25, 2019 | SQLPerformance.com | Performance 0
Tim Radney provides some sage advice about configuring and tuning SQL Server Reporting Services.
September 17, 2019 | SQLPerformance.com | SSRS 0
Itzik Ben-Gan adds another post to his series on T-SQL pitfalls and best practices series, treating complications and limitations of the PIVOT and UNPIVOT operators.
September 12, 2019 | SQLPerformance.com | T-SQL 0
Paul White takes a deep-dive look at the internals of batch mode data normalization and how it can affect execution plans and performance.
September 5, 2019 | SQLPerformance.com | Performance 0
Glenn Berry talks about AMD's current streak of processor innovation and how the single socket EPYC may better serve your SQL Server workloads.
August 27, 2019 | SQLPerformance.com | SQL Server 0
Paul White takes a deep dive into SQL Server batch mode bitmaps revealing undocumented details that can greatly impact performance.
August 23, 2019 | SQLPerformance.com | Performance, SQL Server 0
Itzik Ben-Gan continues a pitfall and best practices series with a post explaining how window functions can go wrong in SQL Server.
August 14, 2019 | SQLPerformance.com | T-SQL 0
Erin Stellato uses simple examples to demonstrate performance benefits you might expect from enabling memory-optimized tempdb metadata in SQL Server 2019.
August 2, 2019 | SQLPerformance.com | tempdb, SQL Server 2019 0
Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.
May 29, 2019 | SQLPerformance.com | SQL Server, Indexes 0
Erin Stellato discusses the performance impact of a predominately adhoc workload in SQL Server.
1 2 3 4 5

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