I noticed this discussion on NOT using ORDER BY in SQL query unless really necessary.
The author suggests that looking at "Query Bucks" which I think in my exec plan is "Estimated CPU cost", that the Sort is very expensive.
Here are the individual operations:
So, up to now I have been looking at exec plan and trying to make the most expensive "Table Scan 97%" more efficient.
BUT maybe I should move to sort completely out of the query and into my C#?