Caching and paging a SQL Result Set

  • Comments posted to this topic are about the item Caching and paging a SQL Result Set

  • Why create SELECT INTO to then have to SELECT INTO the tempdb cache?

    Even better why not create the tempdb table and INSERT into it (with an identity col for an index (say called ROWID)

    Do away with the CTE expressions (which involves sorts and collations each time it is run, and just use a simple SELECT TOP N WHERE ROWID > @x

    Even add a index to the ROWID and get superfast performance!

    cool script got me thinking!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply