Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Pagination Rss

   Items 1 to 3 of 3   
 

Display Complex Hierarchical Data with Server-Side Pagination

This article presents an approach to perform server-side pagination and display complex hierarchical data in Reporting Services.  Read more...
By Peichung Shih 2011/12/22 | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 7,454 reads

Optimising Server-Side Paging - Part II

The second part of this series compares four methods of obtaining the total number of rows in a paged data set.  Read more...
By Paul White 2010/05/24 | Source: SQLServerCentral.com | Category: paging
Rating: |  Discuss |   Briefcase | 8,220 reads

Optimising Server-Side Paging - Part I

This article by Paul White presents an optimisation for paging through a wide data set.  Read more...
By Paul White 2010/04/26 | Source: SQLServerCentral.com | Category: paging
Rating: |  Discuss |   Briefcase | 15,521 reads
   Items 1 to 3 of 3   
 
Tags
paging (2)    
performance tuning (2)    
t-sql (2)    
custom paging (1)    
hierarchyid (1)    
recursive (1)    
reporting services (ssrs) (1)    
server-side pagination (1)    
sql server 2008 r2 (1)