In my SQL presentations at the last couple of IUG conferences, I really wanted to cover window functions but there was never enough time. A recent post on SQLServerCentral offers a very accessible introduction to the syntactic foundations of window functions and is totally worth the read for both Sierra and Polaris query writers.
You can see two examples of how I used PARTITION BY on lines 586–606 of
Collection Health Holds.sql.