My question as to "why" is not "why would you want to send in batches" (the case for this is obvious, and you made it well), but "why would you want to do it all *in SQL Server*". My criticism is of the architecture, not the idea. Use the DB for data operations. Use an application for higher level operations. Don't force it all into the DB. Just because you can do it in SQL Server, doesn't mean that you should.

I understand that on some occasions it is sometimes necessary to hack together something that works, but is not necessarily beautiful, and I am as guilty as anyone of this. The difference is, I wouldn't write an article and post it on the internet telling everyone about it.