My problem with pagination

I recently got into a discussion about a comment I made on a blog post two years ago. Granted; my comment might have come out a bit harsh (for which I apologize) but there was a point to be made. In this blog post I'll try to explain what I was (and am) talking about and what my issues were (and are) with the proposed solution to the problem at hand: pagination of large chunks of data / resultsets.