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,
Be courteous. Drive responsibly.
Follow me on
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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply