Posted by Alexander Kuznetsov on 03/07/06 21:08

> Falling back on
> "by definition" strikes me as mistaking the map for the territory. In
> fact, it's more like believing that the map dictates what the territory
> can be.

Rick,

In general I could agree to that. Yet this is a SQL Server newsgroup,
and specifically for SQL Server (as well as for every other RDMBS I
worked with ;) ) it is not the best practice to sort each and every
result set on the server. In many cases sorting could be done just as
easily on the client, and moving some sorts to the client/midle tier in
many cases leads to much better performance. You can read more about it
here:

http://www.devx.com/dbzone/Article/30149

[Back to original message]