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 missing T-SQL features like the DISTINCT FROM predicate, the NULL treatment clause, and controlling how NULLs are ordered.
February 12, 2020 | SQLPerformance.com | T-SQL, SQL Server 0
Aaron Bertrand continues his series on large table compression with results from row and page compression, and a process involving scheduler manipulation.
February 3, 2020 | SQLPerformance.com | SQL Server, ColumnStore 0
Tuning SQL Server by looking at waits alone and ignoring resources could be costing you time, money, and performance. Greg Gonzalez explains why.
January 24, 2020 | SQLPerformance.com | Wait Stats 0
Jonathan Kehayias shows a simple fix to C# code that can improve performance and throughput of workloads using table-valued parameters.
Itzik Ben-Gan continues his mind-bending series on NULL complexities in T-SQL, treating a variety of constructs, including the MERGE statement.
January 8, 2020 | SQLPerformance.com | T-SQL, SQL Server 0
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

Top Categories

See all
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