Nice article. But I miss a solution for handling a custom sorting when using a paging functionality.

In practice (lets say a ASP.NET application with a GridView component) you need to sort dynamically by another column than the ID. So you have to take care of this before you do the paging.

Look here: http://aspnet.4guysfromrolla.com/articles/032206-1.aspx#

If you combine the custom sort capability together with the discussed Total Row retrieval you can get most out of this...

Cheers