Joe Celko covers it in his book SQL for Smarties (along with lots of other useful things). There is also an Intelligent Enterprise article where he discusses it.