CTE in SQL Server Examples

In this article we cover what a Common Table Expression CTE is and how to write a CTE for doing selects, inserts, deletes, updates and more.

Navigating Trees With CTE

Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]

A Solution for the Bin Packing Problem

A detailed description of a technique for the the solution of the Bin Packing Problem, that involves a recursive CTE and Window functions

Files with larger disk consumption

This script features as we can through the CTE Top10FilesWithLargerDiskConsumption the top ten data files that are showing greater consumption of hard drive related data-reading activities.

Starting a CTE

Recursive Queries

The Christmas CROSS APPLY

Calculate Age (in years)

An inline table valued function (iTVF) that can be used to calculate age in years.

Windowing Functions: Tell me when that changes

Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource

Implementing John Conway's Game of Life in Microsoft SQL Server

A fun exercise, using CTEs to implement John Conway's Game of Life cellular automata simulation