May 6, 2014 at 6:47 pm
Comments posted to this topic are about the item Caching and paging a SQL Result Set
June 6, 2014 at 4:32 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy