Edit: As I reread this, I felt I should clarify.. As usual refers mostly to the ''Scary'' part. I have a lot of stage fright that I have to work through. And it is always exciting to be picked.   I have been selected this year at the PASS Summit 2012 to do two sessions, and they are both going to be interesting. Pre-Con: Relational ...

Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements.  Those who have used the ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE() functions on SQL 2005 and 2008, you already know how useful they are.  They simplify code and can improve performance ...