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

  • 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

  • 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.

  • 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?

  • Nice article, thanks.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]
  • This reply has been reported for inappropriate content.

    would like to show an in-depth look at change detection in SQL Server. ... Create a table with one of the column data type as ROWVERSION.

    https://www.canadapleasure.com

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

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

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