Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Paging and Versioning Using ROW_NUMBER() Expand / Collapse
Author
Message
Posted Wednesday, June 16, 2010 11:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 2:50 AM
Points: 58, Visits: 276
JJ B,

Many thanks for your post and kind comments.

It's certainly been a valuable process for me to discover the performance limitations of ROW_NUMBER(), and be able to demonstrate that they can be overcome with appropriate indexing strategies.

However, it's clear that any ROW_NUMBER() based solution across large amounts of data does have some gotchas. Should the "ideal" index(es) not be available, or can't be created due to environmental constraints, other solutions are faster.

As always, it's about understanding your data and the queries that are run across it.

Kind regards,
Lawrence
Post #938424
Posted Wednesday, June 16, 2010 1:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2014 3:07 PM
Points: 1, Visits: 47
Mr. Lawrence Moore,

Then according to this algorithm,
Is will be possible to predict how many pages will be in the Query?
Post #938520
Posted Wednesday, June 16, 2010 2:09 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 2:50 AM
Points: 58, Visits: 276
Jesus,

I'm not completely sure what you are asking.

Could you elaborate please?

Many thanks,
Lawrence
Post #938540
Posted Thursday, June 17, 2010 8:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 7, 2012 10:14 AM
Points: 27, Visits: 30
Good one.. :)
Post #938926
Posted Monday, June 21, 2010 8:19 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 1, 2010 4:19 AM
Points: 39, Visits: 150
some solutions become simple and convenient since RANK function(NOW_NUMBER,RANK and DENSE_RANK).
Post #940725
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse