Home Forums SQL Server 2005 T-SQL (SS2K5) checksums and unicode data RE: checksums and unicode data

  • August 9, 2009 at 12:36 pm

    #1036505

    Paul White (8/8/2009)

    HashBytes (perhaps including the PK as a salt) is a good choice if the task is to detect changes.

    CHECKSUM is quick and efficient for creating hash indexes - which are awesome if you need to search long strings (for example).

    Even then, it can and will give an incorrect answer if you rely only on it. I'll admit that CHECKSUM will help narrow things down on long strings, though.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)