A "must use" SQL Server 2005 Feature-ROW_NUMBER()http://rentacoder.com/CS/blogs/real_life_it/archive/2006/04/29/481.aspx If you run your SQL Server as the back end for a website, then paging is one of the most common things that you do.  In SQL Server 2000, doing this paging was complicated and resource intensive.  But in 2005, there is a new feature calleden-USCommunityServer 2.0 (Build: 60217.2664)Lessons learned from upgrading from SQL 2000 to SQL Server 2005http://rentacoder.com/CS/blogs/real_life_it/archive/2006/04/29/481.aspx#507Fri, 26 May 2006 18:32:44 GMT2b679553-572d-4457-89da-485055e17287:507AnonymousWe recently upgraded from SQL Server 2000 to SQL 2005.  We simultaneously did a serious upgrade...