SQL Performance Archives - Page 5 of 31

Performance of sys.partitions

Aaron Bertrand investigates what makes sys.partitions slow and shows that the unsupported sys.system_internals_partitions is more efficient.

Aaron Bertrand ◆ January 19, 2021

7

A use case for sp_prepare / sp_prepexec

Aaron Bertrand explains a scenario where sp_prepare came in handy trying to validate a plan guide's impact.

Aaron Bertrand ◆ January 11, 2021

0

Parse parameter default values using PowerShell – Part 3

Aaron Bertrand provides more background on the evolution of ParamParser, a PowerShell module that helps parse parameters from stored procedures and functions.

Aaron Bertrand ◆ October 16, 2020

0

When Do SQL Server Sorts Rewind?

Paul White explains when a SQL Server sort operator inside a loop rewinds (replays) cached results to avoid re-executing plan operators.

Paul White ◆ October 7, 2020

0

Parse parameter default values using PowerShell – Part 2

Aaron Bertrand continues explaining the evolution of a new GitHub repository for parsing parameter default values using PowerShell.

Aaron Bertrand ◆ October 1, 2020

0

Parse parameter default values using PowerShell – Part 1

Aaron Bertrand talks about a new project involving parsing the default values for parameters out of stored procedure and function bodies.

Aaron Bertrand ◆ September 25, 2020

1

Sometimes you CAN upsize a column in-place

Altering a fixed-width column on a large table can often mean either a lot of planning or a lot of downtime, but in some scenarios there may be an easy out.

Aaron Bertrand ◆ August 19, 2020

0

Fundamentals of table expressions, Part 4 – Derived tables, optimization considerations, continued

Continuing his series on table expressions in SQL Server, Itzik Ben-Gan discusses more considerations for performance and efficiency.

Itzik Ben-Gan ◆ July 8, 2020

4

Fundamentals of table expressions, Part 3 – Derived tables, optimization considerations

Itzik Ben-Gan continues his series on table expressions in SQL Server, with some things you should keep in mind for performance and efficiency.

Itzik Ben-Gan ◆ June 10, 2020

1

Visualizing the Tipping Point with Plan Explorer

Greg Gonzalez shows off some new functionality in SentryOne Plan Explorer that literally visualizes the tipping point overlaying the histogram.