Efficient Paging in SQL Server 2005

Sure, SQL Server 2008 is getting ready to drop, but are you familiar with all of the new features that 2005 gave you? Or maybe you haven't used 2005, well, this is a good article to introduce to you several of the new features in SQL Server 2005.