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

Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.
Itzik Ben-Gan explains log buffer flushes and shows how to use them to help balance performance, transaction size, and durability.
November 14, 2018 | SQLPerformance.com | T-SQL, Transaction Log 0
Glenn Berry goes over three different tactics you can use to squeeze some extra performance out of SQL Server without a lot of heavy lifting.
Tim Radney talks about some of the things you can do to prepare for the end of extended support for SQL Server 2008 and SQL Server 2008 R2.
October 12, 2018 | SQLPerformance.com | SQL Server 0
Itzik Ben-Gan steps through an interesting reader submission for his "Special Islands" challenge from last month, with some surprising performance implications.
October 10, 2018 | SQLPerformance.com | T-SQL 0
Itzik Ben-Gan explains the mechanics behind some different approaches to solving gaps and islands problems in T-SQL.
September 12, 2018 | SQLPerformance.com | T-SQL 0
Glenn Berry lays out a convincing argument to upgrade to a modern version of SQL Server -- considering not only the platform improvements but also changes to Windows, storage, and hardware.
Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer).
Erin Stellato shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database.
In the conclusion of his series on grouping and aggregation costs, Itzik Ben-Gan reveals some of the math behind seek vs. scan decisions.
Glenn Berry of SQLskills.com describes the different tiers for Azure SQL Database, and what you get for your money in each case.
Andy Mallon dispels the myth that SQL Server maintains some kind of query result cache to make future executions of the same query faster.
Jonathan Kehayias of SQLskills.com shares his story of an unusual situation with high CLR_MANUAL_EVENT waits and how he resolved it.
July 18, 2018 | SQLPerformance.com | Wait Stats 0
In the fourth installment of his series on optimization thresholds, Itzik Ben-Gan looks at how SQL Server applies costs to parallel operations.
For his first guest post on SQLPerformance.com, Bert Wagner describes the pros and cons of join elimination in SQL Server.
June 18, 2018 | SQLPerformance.com | T-SQL 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