The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

I had just been playing around with these three functions this morning and for the life of me I could not remember what DENSE_RANK provided.

The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

Hat tip to the excellent DBWeekly for the link.