Efficient data paging with SQL Server 2005 using ROW

Why not join our community?, there are 8 users online

home
database
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

30
kicks

kick it

Efficient data paging with SQL Server 2005 using ROW_NUMBER()

published 1 year ago, submitted by jdee 1 year ago

j-dee.com — 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: 9 | Get KickIt image code

tags: Database, 2005, SQL | tag it

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:

jdee -

marshp3 -

tiernano - gantww - funkybeatz - skydata - rocjoe71 - mghaoui - mboyda - csharpnjava -

offwhite -

sirrocco - rg443 - datacom -

gavinjoyce - RobChappel - MarthaBass -

dove -

simoneb - moeen49 - motionblur - jeremyh - gmiller - gmiller - Loonquawl - photoz - senfo - mihai.guta - bayarsaikhan -

dzeng

Comments:

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

posted by

marshp3 1 year ago

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 libardo 1 year ago

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

posted by senfo 1 year ago