Analyzing Tempdb Spills and Usage Across Recursive Queries

This article examines how tempdb is affected by recursive queries, using a few different methods.

Parsing a Pairs of Values in a String While Preserving Order

Learn how you can parse a series of parameters that are passed in a string of tuples, meaning pairs, of values and preserve order without using STRING_SPLIT with the ordinal parameter.

The Self Referencing CTE

Calculating Prime Numbers With One Query

This article looks at calculating prime numbers less than n with one query.

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node.  The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression. 

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node.  The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression. 

Recursive CTE calculations

Reusing the previous value of a recursive CTE to construct the new value

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.