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
Number series generator challenge solutions – Part 1 Itzik Ben-Gan presents and evaluates reader submissions to last month's number series generator challenge. Itzik Ben-Gan ◆ January 13, 2021 17
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
The challenge is on! Community call for creating the fastest number series generator Itzik Ben-Gan offers up a challenge to the SQL Server community: let's create a more efficient number series generator together. Itzik Ben-Gan ◆ December 9, 2020 72
Fundamentals of table expressions, Part 8 – CTEs, optimization considerations continued Itzik Ben-Gan further discusses optimizing CTEs, with a focus on some unintuitive behavior of multiple references to a single CTE. Itzik Ben-Gan ◆ November 11, 2020 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
Fundamentals of table expressions, Part 7 – CTEs, optimization considerations With another entry in his series on table expressions, Itzik Ben-Gan discusses some issues around optimizing CTEs. Itzik Ben-Gan ◆ October 14, 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
Fundamentals of table expressions, Part 6 – Recursive CTEs Continuing a series on table expressions, Itzik Ben-Gan explains recursive CTEs, features from the standard T-SQL is lacking, and workarounds. Itzik Ben-Gan ◆ September 9, 2020 0
