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 …
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 …
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 …
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.
Glenn Berry, Author at SQLPerformance.com
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 …
Aaron Bertrand, Author at SQLPerformance.com
Jul 24, 2022 · Aaron Bertrand talks about NULLs, the logical issues with avoiding them, and potential performance impacts.
What impact can different cursor options have?
Sep 20, 2012 · SQL Sentry's @AaronBertrand discusses the default cursor options in SQL Server and why, in many cases, you'll want to override them.
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.