You are here: Re: ORDER BY in VIEW not working « MsSQL Server « IT news, forums, messages
Re: ORDER BY in VIEW not working

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация