SQL Server and ASP.Net

Have you developed web applications that requires you to provide pagination support for large amount of data? What will you do? A naive way would be to retrieve the entire results, and then limiting it to those ranges you are interested in.

Check out
http://weblogs.asp.net/scottgu/archive/2006
/03/22/440900.aspx

which shows you how to do this efficiently with SQL Server 2005 + Atlas.