Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 handle paging with large datasets

Author  Topic 

BitShift
Yak Posting Veteran

98 Posts

Posted - 2008-04-10 : 17:31:04
Im looking at this article [url]http://www.dotnetjunkies.com/Article/EA868776-D71E-448A-BC23-B64B871F967F.dcik[/url]
and it seems like they are selecting the entire customers table into the temp table, correct ?

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2008-04-10 : 17:39:30
Yep.

Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-10 : 17:40:05
There are many techniques for doing this.
Most of them (it not all) have been discussed here at SQLTeam.

This may be a starter
http://weblogs.sqlteam.com/peterl/archive/2008/02/19/Efficient-pagination-for-large-set-of-data.aspx



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -