Deprecated features to take out of your toolbox – Part 1 Aaron Bertrand provides evidence about SQL Server features you should stop using, like sysprocesses, but not just because they've been deprecated. Aaron Bertrand ◆ February 22, 2021 1
How to Write a Query with Multiple Behaviors Guy Glanster explores the multiple behaviors of queries designed to support user-specified filtering and sorting. Guy Glanster ◆ February 16, 2021 1
Number series generator challenge solutions – Part 2 Itzik Ben-Gan digs deeper into reader submissions to a recent challenge for an efficient number series generator. Itzik Ben-Gan ◆ February 10, 2021 13
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 70
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
