First read this article by Zach Nichter of the Scalability Experts. Some interesting performance tests.
What I would really like to see is one more test, vs. an extended stored procedure, although perhaps that doesn't qualify as a solution that most people would employ for solving the problem...
Anyway, a good read at any rate.