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 starts a new series discussing the fundamentals of table expressions, a commonly misunderstood feature in T-SQL.
Aaron Bertrand continues his series on replacing the default trace with a more efficient and more complete Extended Events session.
April 6, 2020 | SQLPerformance.com | SQL Server, Trace 0
Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations.
March 26, 2020 | SQLPerformance.com | SQL Server, Indexes 0
Aaron Bertrand pushes for improvements to STRING_SPLIT in the next version of SQL Server. See how you can help!
March 20, 2020 | SQLPerformance.com | SQL Server 0
Paul White explains a few different ways to retrieve distinct values from a table, including some big "it just runs faster" wins in SQL Server 2019.
March 17, 2020 | SQLPerformance.com | T-SQL, SQL Server 2019 0
Continuing his treatment of NULLs in SQL Server, Itzik Ben-Gan covers how SQL Server's implementation of unique constraints differs from the standard, and how you can work around it.
March 11, 2020 | SQLPerformance.com | T-SQL, SQL Server 0
Jonathan Kehayias starts a new blog series where he tests the impact that a specific plan shape might have on ASYNC_NETWORK_IO waits.
Aaron Bertrand starts a series on how he evaluated the default trace and replaced it with a slimmer Extended Events session across all of production.
Tim Radney talks about how to decide whether a move to Azure SQL Database Managed Instance makes sense and, if so, which tier.
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

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