An in-depth look at change detection in SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Nakul Vachhrajani » An in-depth look at change detection in SQL...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Nakul Vachhrajani

Posted Tuesday, February 12, 2013 12:00 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:02 AM
Points: 1,277, Visits: 1,609

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://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul

Post #1418764

arun1_m1

Posted Tuesday, February 12, 2013 2:14 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:25 PM
Points: 811, Visits: 440

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.

Post #1418805

tomasz.libera

Posted Tuesday, February 12, 2013 2:59 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 3:19 AM
Points: 15, Visits: 180

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?

Post #1418823

« Prev Topic | Next Topic »

Permissions