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

Christmas 2018 Trivia

The Lost Last Value

Introduction to T-SQL Window Functions

T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of these useful functions. In this article, Kathi Kellenberger provides a quick overview of just what a window function is as well as examples of each type of function.

The Strange First Value

Window Functions for Row Number

Window Function defaults

Solving FIFO Queues Using Windowed Functions

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.

Relative Rank

The Last Order