I have found that getting a count(*) on most of the things I would page is simply nonsensical from a performance perspective.

Usually I have put in a system to...

The point is that you DONT need to count anything.

You need something vaguely sequential though, but I don't see how you could ever page anything if you didn't have some...

I'm pretty sure it should work with any orderable criteria.

The real question I have is whether this is stable behaviour of rowcount and select @variable, or if this is leveraging...

Apologies for resurrecting a long dead thread...

One of my devs has brought http://www.4guysfromrolla.com/webtech/042606-1.shtml to my attention.

It seems to work extremely well - needing only a page number...

Ok, thought I'd let you know how this ended up.

1 - Re-exported the data into 400m chunks. With 5 exports in parallel the export took a little over 5hrs.

2...

Thanks jeff.

Well, the file might be 200gb. Not sure what the ordering is going to be like, but the original table is clustered differently to the final table....

I guess taking this along to its conclusion...

assuming you have a nice big das array of 56 disks...

Assuming you keep 2 back as h/s:

Would you want to go with 27...

Thanks for the replies - the shining was especially interesting.

Dont currently have a tape drive, But I assume direct attach either fibre or scsi would be possible.

Are tape drives clusterable...

you could think about maybe denying select to that user on that table?

heh - due to my reading habit of merging words from line above/below into the one i'm reading where they make sense - I read the backup had been created...

course - if you have any big tables that would take a while.

We use sysindexes - as count(*) over 2 billion records may offend.

Oh and on 2000 at least sp_spaceused...

Truly excellent article, thanks.

Thats actually the solution I have recommended.... 😎

No - but...

ok - we've found a better size MTU window. Seems to chuck the data across more than 5x speed.

Much, much better 🙂