Greg Gonzalez shows off some new functionality in SentryOne Plan Explorer that literally visualizes the tipping point overlaying the histogram.
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.
Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations.
Aaron Bertrand pushes for improvements to STRING_SPLIT in the next version of SQL Server. See how you can help!
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.
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.
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.
Aaron Bertrand continues his series on large table compression with results from row and page compression, and a process involving scheduler manipulation.
Tuning SQL Server by looking at waits alone and ignoring resources could be costing you time, money, and performance. Greg Gonzalez explains why.
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.
