February 12, 2013 at 12:00 am
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.comBe courteous. Drive responsibly.
Follow me onTwitter: @sqltwins
February 12, 2013 at 2:14 am
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
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
Nice article, thanks.
September 11, 2020 at 9:52 am
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.
November 9, 2020 at 7:38 am
This was removed by the editor as SPAM
December 21, 2020 at 2:51 am
April 8, 2021 at 7:35 am
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply