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 application, then I would suggest that you create a clustered index instead, in the manner that you want the data to be sorted (that is, how you declare the sorting using the order by clause). That way, you'll be able to retrieve results much faster with less resources used.