Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

An in-depth look at change detection in SQL Server - Part 01 Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2013 12:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, April 20, 2014 11:47 PM
Points: 1,382, Visits: 1,775
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
Posted Tuesday, February 12, 2013 2:14 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, April 20, 2014 3:42 PM
Points: 854, Visits: 513
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
Posted Tuesday, February 12, 2013 2:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 15, Visits: 198
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 »

Add to briefcase

Permissions Expand / Collapse