Efficient data paging with SQL Server 2005 using ROW

home
database
view story

30 Kicks

Efficient data paging with SQL Server 2005 using ROW_NUMBER()(j-dee.com)

submitted by jdee(270) 4 years, 6 months ago

Paging large amounts of data in SQL Server 2000 used to be a real pain, creating temporary tables, suffering bad performance after the first few batches of data or using ROWCOUNT to ignore large numbers of rows. Luckily SQL Server 2005 delivers a couple of new functions to make efficient painless data paging a reality.

3 comments |category: Database |Views: 163
Tweet

tags: 2005 SQL Database another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

More who kicked this story...

Comments:

posted by marshp3(965) 4 years, 6 months ago 0

Love it... gonna try it too. Had to page in so many apps using temp tables and the like

posted by libardo(5) 4 years, 6 months ago 0

On a related topic, Frans mention a generic paging wrapper code: http://weblogs.asp.net/fbouma/archive/2007/06/05/sqlserver-2005-paging-there-is-a-generic-wrapper-query-possible.aspx

posted by senfo(881) 4 years, 6 months ago 0

Well that's pretty cool! Thank you for sharing!

Most Active Users

What's this?