Posted by DA Morgan on 08/07/06 00:43

Erland Sommarskog wrote:
> Bjørn Augestad (bjorn.augestad@gmail.com) writes:
>> Erland Sommarskog wrote:
>>> 20% may sound significant, but there other ways to get a 20% speedup,
>>> for instance by sticking to a binary collation,
>> What about proper sorting of our æøå's and other funny european
>> characters? Won't work, will it?
>
> Correct. A binary collation comes with a price. So does raw partitions.

Would you please explain what you intend with this comment about block
devices. With any database, other apparently than Microsoft's, there is
an advantage that accrues to those who forgo file systems. Why is SQL
Server different?

Thanks.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

• Next in forum: Re: SQL Server 2005 and file systems, any recommendations
• Prev in forum: Move from SBS2003 MSDE to MS SQL 2005 Express
• Thread view: Re: SQL Server 2005 and file systems, any recommendations

[Reply to this message]