Suppose that you need to reduce the load of traffic between the Microsoft SQL 2005 DB
and application in case of client \ server application also reduce the load of traffic between
client and application server. One of the known methods is Paging .
In a simple example below, I'll show you how to implement Paging method at SQL 2005
Create and fill temporary table #someTable for example :
We'll use page size=2 ,FieldA as sort field and page number = 1
The result as you can see two rows sorted by FieldA :
The example showed us the MS SQL 2005 server side implementation of paging technique
the application server/client paging techniques is another post issue ,but the common idea
identical to this one that implemented here.