Mr or Mrs. 500
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)