SQLPerformance.com - SQL Server Performance Articles
Oct 4, 2022 · SQLPerformance delivers innovative and practical solutions for improving SQL Server performance.
About SQLPerformance.com - SQLPerformance.com
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 …
Categories - SQLPerformance.com
The SQLPerformance.com bi-weekly newsletter keeps you up to speed on the most recent blog posts and forum discussions in the SQL Server community. eNews is a bi-monthly newsletter …
Latest Builds - SQLPerformance.com
Find latests builds of all currently supported versions of SQL Server, Management Studio, and SentryOne software.
UNION ALL Optimization - SQLPerformance.com
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 …
FORMAT () is nice and all, but… - SQLPerformance.com
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, …
Pagination with OFFSET / FETCH : A better way
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.
Aaron Bertrand, Author at SQLPerformance.com
Jul 24, 2022 · Aaron Bertrand talks about NULLs, the logical issues with avoiding them, and potential performance impacts.
Performance Surprises and Assumptions : GROUP BY vs. DISTINCT
Jan 26, 2017 · I'd be interested to know if you think there are any scenarios where DISTINCT is better than GROUP BY, at least in terms of performance, which is far less subjective than style …
Paul White, Author at SQLPerformance.com
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.