Paging in the Set values | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Paging in the Set values

Hi All, I have got huge number of rows (1,00,000) in the view. I want to get top 15 values when a click event done on the page number. For every next page click event get next 15 records from the database. Can you plz provide any solution Thank You With Regards
Aruna Mathew

Paging Records Using SQL Server 2005 Database – ROW_NUMBER Function
http://davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx http://www.sqlmag.com/articles/index.cfm?articleid=43922&
MohammedU.
Moderator
SQL-Server-Performance.com
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |