Post reply

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

  • February 12, 2013 at 12:00 am

    #394162

    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

    Follow me on
    Twitter: @sqltwins

  • February 12, 2013 at 2:14 am

    #1586880

    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.

  • February 12, 2013 at 2:59 am

    #1586894

    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?

  • August 13, 2014 at 9:47 am

    #1737669

    Nice article, thanks.

    qh

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

  • September 11, 2020 at 9:52 am

    #3787815

    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

  • November 9, 2020 at 7:38 am

    This was removed by the editor as SPAM

  • December 21, 2020 at 2:51 am

    This was removed by the editor as SPAM

  • April 8, 2021 at 7:35 am

    This was removed by the editor as SPAM

  • September 28, 2021 at 11:23 am

    This was removed by the editor as SPAM

  • September 28, 2021 at 11:25 am

    This was removed by the editor as SPAM

  • March 22, 2022 at 3:16 am

    This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

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