Posted by Erland Sommarskog on 08/06/06 21:51

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.

> Another thing: Have you got any links to a site describing proper use of
> SARGs and operators and the query optimizer? I threw away my copy of SQL
> Server Unleashed (never do that) and have forgotten all about it. The
> Unleashed for 2005 won't we available until Nov. 27th...

No direct link, but the obvious place to look around would be
http://www.sql-server-performance.com/


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Server 2005 and file systems, any recommendations
• Prev in forum: Re: SQL Server 2005 and file systems, any recommendations
• Thread view: Re: SQL Server 2005 and file systems, any recommendations

[Reply to this message]