Do Paging in Denali
When you have a large table many times you create paging in your application allowing for faster responsiveness to the application.
Most systems don’t have some form of caching system and require the database query to determine the sort order, offset where a page records should begin, and the number of records to return for the current page.
If you search Google there are many different ways this has been implemented. In the Denali release, Microsoft has implemented a syntax that is much easier to generate a page of data.
For example:
select Table_Name
from sys.objects
Order by name
Offset 5 rows
Fetch Next 10 Rows ONLY;