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 10
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 3
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 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
