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.
| Author |
Topic |
|
vishal_7
Posting Yak Master
127 Posts |
 Posted - 2005-04-11 : 18:03:15
|
| Hello, what is the best way to do paging on the sql server? I have seen procedures which creates temp tables and also seen queries which use the top statement to get a specific row range. I dont know if there are any other methods out there. I use mostly the temp tables, however I would like to know if this is a good approach.Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-11 : 19:02:27
|
| There are a few, you might want to read these (if you haven't already):http://www.sqlteam.com/searchresults.asp?SearchTerms=tophttp://weblogs.sqlteam.com/jeffs/archive/2004/03/22/1085.aspxIf you are a member of PASS:http://www.sqlpass.org/You can check the Community Summit 2004 technical articles here:http://www.sqlpass.org/events/summit04/index.cfmThere was a presentation titled "Calling All Options: Paging SQL Server Data", the session number is 210. It covers almost every available option, including new ones available in SQL Server 2005, and their strengths and weaknesses. If you're not a member of PASS, I stronly recommend it, especially the Summit Conferences. |
 |
|
|
|
|
|
Best way to do paging?