Analytics in Action

Archive for August, 2013

Window Functions in T-SQL (Ranking, Cumulative totals, Row counts, First and Last values)

Window functions allow you to apply calculations against "sets" or groups of data. These sets are known as windows. Many books classify window functions as an advanced topic in T-SQL. But in fact, once you see some practical examples window...

Creating Temporary Tables with Transact SQL

Temporary Tables are a handy technique for creating cascading logic. Results from one temporary table can be passed to other temp tables. This can simplify the process for creating complex result sets. Temporary tables are saved to disk, and are...