Deprecated features to take out of your toolbox – Part 2 With a real-world example, Aaron Bertrand discusses why you shouldn't use deprecated functionality like SQL Server Profiler. Aaron Bertrand ◆ March 15, 2021 4
Number series generator challenge solutions – Part 3 Itzik Ben-Gan continues working with several readers to squeeze all the performance he can out of a number series generator. Itzik Ben-Gan ◆ March 10, 2021 9
Understanding Execution Plan Operator Timings How SQL Server actual execution plan operator timings work, and why parallel row mode plan timings can be misleading, by Paul White. Paul White ◆ March 8, 2021 3
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
