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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 6:47 AM
Points: 1,434, Visits: 1,846
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.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
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: Thursday, September 4, 2014 9:32 AM
Points: 859, Visits: 517
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: Thursday, May 8, 2014 4:04 PM
Points: 15, Visits: 200
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
Posted Wednesday, August 13, 2014 9:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:56 AM
Points: 2,406, Visits: 1,000
Nice article, thanks.

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1602836
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse