Paging and Versioning Using ROW

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Lawrence Moore » Paging and Versioning Using ROW_NUMBER()

25 posts, Page 3 of 3

«««1 2 3

Paging and Versioning Using ROW_NUMBER()

Rate Topic

Display Mode

Topic Options

Author

Message

Lawrence Moore

Posted Wednesday, June 16, 2010 11:03 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:16 AM
Points: 58, Visits: 263

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

jesus salazar

Posted Wednesday, June 16, 2010 1:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 10:20 AM
Points: 1, Visits: 45

Mr. Lawrence Moore,

Then according to this algorithm,
Is will be possible to predict how many pages will be in the Query?

Post #938520

Lawrence Moore

Posted Wednesday, June 16, 2010 2:09 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:16 AM
Points: 58, Visits: 263

Jesus,

I'm not completely sure what you are asking.

Could you elaborate please?

Many thanks,
Lawrence

Post #938540

sandeep.cs3

Posted Thursday, June 17, 2010 8:00 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 07, 2012 10:14 AM
Points: 27, Visits: 30

Good one.. :)

Post #938926

changbluesky

Posted Monday, June 21, 2010 8:19 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, November 01, 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 »

25 posts, Page 3 of 3

«««1 2 3

Permissions