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.
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.
A Tale of Two Saturdays
November 17, 2013
Thoughts on two SQL Saturdays events, back to back