SQL Partition clause

Here is something I did not know: SQL 2005: Subtotals and Totals

And I can think of a couple of places where things would have been much easier knowing it.