Zach,

The research looks great and the article is nice explains itself very good. In SQL Server or any RDBMS partitioning large table helps in many ways and batch processing always improves the performance. It is all depends on your server and database architect.

I like this document. I use to work for him 10 years ago.. 🙂