Using T-SQL windowing functions to calculate the median value of a collection

December 6, 2013

SQL Server T-SQL CTE Common table expression and windowing functions used to find median value of a collection.

Read on

My Query Optimization Story: Comparing the T-SQL OR VS UNION operators in a multi-table JOIN

December 2, 2013

Comparing T-SQL query performance of the UNION clause vs WHERE/OR construct in a multi-table query filter.

Read on

A Tale of Two Saturdays

November 17, 2013

Thoughts on two SQL Saturdays events, back to back

Read on