Oct 4, 2022 · SQLPerformance delivers innovative and practical solutions for improving SQL Server performance.

We’re dedicated to covering the “how” and “why” of your performance conundrums. Our guidance will provide you with functional knowledge to improve performance whether or not you are in control of …

Find latests builds of all currently supported versions of SQL Server, Management Studio, and SentryOne software.

Oct 4, 2022 · Paul White explains how and when lock escalation is triggered in SQL Server, clarifying misleading information you may have seen in official documentation and other sources.

Jul 24, 2022 · Aaron Bertrand talks about using partition switching to load refreshed SQL Server tables without impacting current users.

These articles were written by several of the SQL Server industry’s leading experts, including Paul White, Paul Randal, Jonathan Kehayias, Erin Stellato, Glenn Berry, Aaron Bertrand, and Joe Sack. …

Aug 27, 2019 · Glenn Berry provides some details about how compatibility levels and the cardinality estimator have changed over the years, and why modern versions of SQL Server continue to be the …

May 10, 2017 · By default, SQL Server optimizes execution plans on the basis that all qualifying rows will be returned to the client. When a row goal is in effect, the optimizer tries to find an execution plan …

Jan 12, 2015 · Learn about SQL Server pagination, including what it is, best practices, and how to fetch data better by optimizing queries that use OFFSET/FETCH pagination.

Jun 29, 2015 · Back when SQL Server 2012 was still in beta, I blogged about the new FORMAT() function: SQL Server v.Next (Denali) : CTP3 T-SQL Enhancements : FORMAT (). At that time, I was …