I was just writing a response to a comment on my ''Sell Yourself!'' presentation (http://sqlblog.com/blogs/michael_coles/archive/2010/12/05/sell-yourself-presentation.aspx#comments), and it started getting a little lengthy so I decided to turn it into a blog post.  The ''Sell Yourself!'' post got a couple of very good comments on the ...

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 ...