SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Nakul Vachhrajani / An in-depth look at change detection in SQL Server - Part 01 / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 19:48:02 GMT20RE: An in-depth look at change detection in SQL Server - Part 01http://www.sqlservercentral.com/Forums/Topic1418764-2785-1.aspxHello,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 | 991901348Is it connected with collation?Tue, 12 Feb 2013 02:59:51 GMTtomasz.liberaRE: An in-depth look at change detection in SQL Server - Part 01http://www.sqlservercentral.com/Forums/Topic1418764-2785-1.aspxGreat 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.Tue, 12 Feb 2013 02:14:22 GMTarun1_m1An in-depth look at change detection in SQL Server - Part 01http://www.sqlservercentral.com/Forums/Topic1418764-2785-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/change+detection/95930/">An in-depth look at change detection in SQL Server - Part 01</A>[/B]Tue, 12 Feb 2013 00:00:51 GMTNakul Vachhrajani