An in-depth look at change detection in SQL Server - Part 01

  • Nakul Vachhrajani

    SSChampion

    Points: 10151

    Comments posted to this topic are about the item An in-depth look at change detection in SQL Server - Part 01

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com
    Be courteous. Drive responsibly.

    Follow me on
    Twitter: @sqltwins

  • arun1_m1

    SSCommitted

    Points: 1949

    Great article Nakul.

    Another use of the Checksum is for the hash index creation. When indexes are created over nvarchar or varchar datat type columns, CHECKSUM() hashes the value. This could help in over-riding the 900 byte limit posed during the index creation.

  • tomasz.libera

    Old Hand

    Points: 361

    Hello,

    Thanks for great article. I have one question.

    Example "CHECKSUM may fail to detect a change" works diffrent on my SQL Server. It returns:

    Before Change | After Change

    -546463845 | 991901348

    Is it connected with collation?

  • quackhandle1975

    SSChampion

    Points: 10963

    Nice article, thanks.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

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

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