For some reason they trusted me to do the first one. It went very well: Ranking and Windowing Functions in SQL Server 2005. After editing, you can view it here: http://www.groktalk.net/blog/
Page rendered at Tuesday, January 19, 2021 12:37:15 AM (Eastern Standard Time, UTC-05:00)
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.