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

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.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table.
Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.
Paul Randal provides a detailed introduction to troubleshooting SQL Server workload performance using wait statistics.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index.
Guest author Dustin Dorsey shows how to prepare for a migration to Azure SQL Database by sending SentryOne monitoring data to the DTU calculator.
Paul White goes deep on grouped aggregation pushdown, and explains examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX.
April 23, 2019 | SQLPerformance.com | SQL Server, ColumnStore 0
Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.
April 10, 2019 | SQLPerformance.com | T-SQL, SQL Server 0
Glenn Berry talks about the AMD EPYC CPUs now found in Azure Virtual Machines (in some regions) and their usage in balanced SQL Server workloads.
April 8, 2019 | SQLPerformance.com | Azure 0
Paul White explains why the IGNORE_DUP_KEY index option on a clustered index can result in much poorer performance than for a nonclustered unique index.

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