Note To Self
Don't put ORDER BY Statements in Views.
Delay sorting until you're actually about to use the data.
If you end up sorting differently than the default sort specified by the ORDER BY in the view, it comes as an expensive performance hit. Witness a stored procedure that was breaking a unit test due to a SqlClient.SqlTimeout Exception (took 2.5 minutes to run). Removing the ORDER BY statements from the underlying views brought execution time down to 6 seconds.
If I ever catch me putting ORDER BY statements in views again, I grant myself permission to kill me :-).
It's hard being a self-taught programmer sometimes. Will they cover this issue when I get to my relational database courses in college?