Post reply

Collation Settings

  • March 28, 2006 at 1:26 pm

    #114043

    Can the collation settings on a server cause performance issues?

    TIA

  • March 29, 2006 at 8:42 am

    #629510

    Yes.  Binary sort order is the fastest (but probably the least useful).  From BOL:

    "Sorts and compares data in Microsoft® SQL Server™ tables based on the bit patterns defined for each character. Binary sort order is case-sensitive, that is lowercase precedes uppercase, and accent-sensitive. This is the fastest sorting order.

    If this option is not selected, SQL Server follows sorting and comparison rules as defined in dictionaries for the associated language or alphabet."

    I imagine also that case-sensitive and accent-sensitive collations are faster than case-insensitive and accent-insensitive because SQL Server does not need to waste time, for example, checking whether "A" is equivalent to "a".

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply