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

Aaron Bertrand continues his series on investigating compression a 1TB table, honing in on clustered columnstore and partitioning.
January 7, 2020 | SQLPerformance.com | SQL Server, ColumnStore 0
Aaron Bertrand starts a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.
December 27, 2019 | SQLPerformance.com | ColumnStore 0
Glenn Berry describes different types of Azure VMs and explains which might be better suited to your SQL Server workload.
December 17, 2019 | SQLPerformance.com | SQL Server, Azure 0
Itzik Ben-Gan kicks off a new series of Transact-SQL blog posts treating NULL handling in SQL Server.
December 11, 2019 | SQLPerformance.com | T-SQL, SQL Server 0
Aaron Bertrand shows a simple way to keep your filtered indexes effective even under forced parameterization.
December 3, 2019 | SQLPerformance.com | SQL Server, Indexes 0
Tim Radney talks about the performance trade-offs when deciding between various VM sizes in Azure.
November 18, 2019 | SQLPerformance.com | SQL Server, Azure 0
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

Top Categories

See all

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