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
