Scott Guthrie has an excellent example of how to do real-world paging of data records pulled from the DB, usingĀ a new feature of SQL Server 2005.
Must read.