T-SQL Queries Archives - Page 3 of 17

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

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

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

Please stop using this UPSERT anti-pattern

There is a very common anti-pattern you should avoid, involving updating a row if it exists and inserting it if it doesn't. See how to avoid race conditions and deadlocks.

Aaron Bertrand ◆ September 2, 2020

5

Fundamentals of table expressions, Part 5 – CTEs, logical considerations

Continuing with table expressions, Itzik Ben-Gan compares CTEs to derived tables and addresses some logical considerations.

Itzik Ben-Gan ◆ August 12, 2020

8

Fundamentals of table expressions, Part 4 – Derived tables, optimization considerations, continued

Continuing his series on table expressions in SQL Server, Itzik Ben-Gan discusses more considerations for performance and efficiency.

Itzik Ben-Gan ◆ July 8, 2020

4