Viewing 3 posts - 1 through 3 (of 3 total)
ORDER BY is actually a very expensive operation in sql server. If you're using a table variable or a temp table to insert rows peior to displaying it on the...
March 6, 2013 at 11:59 am
I think it would be best to recreate the table (create a similar structure witj tmp_xxx prefixed to the actual name of the table) and then insert only the rows...
March 6, 2013 at 11:38 am
March 6, 2013 at 11:32 am