SQL Server Performance

Sort Order

Discussion in 'Preguntas sobre SQL Server en Español.' started by c_maldon, Apr 12, 2005.

  1. c_maldon Member

    Cual es el sort order default de SQL Server 2000?

    Conviene salirse del default?

    Saludos
    c_maldon, Apr 12, 2005
    #2

  2. Luis Martin Moderator

    El default depende de la region de la instalación. Por ejemplo aquí el default es:
    Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data

    Cambiarlo de depende exclusivamente de las necesidades de la aplicación. De ninguna manera afecta la performance.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Apr 13, 2005
    #2

Share This Page