Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag checksum Rss

   Items 1 to 9 of 9   
 

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...
By Nakul Vachhrajani 2013/03/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,728 reads

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

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.  Read more...
By Nakul Vachhrajani 2013/02/19 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 5,944 reads

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

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.  Read more...
By Nakul Vachhrajani 2013/02/12 | Source: SQLServerCentral.com | Category: change detection
Rating: |  Discuss |   Briefcase | 2,799 reads

Confessions of a DBA: My Worst Mistake

To kick off a series of DBA worst case scenarios, we asked Phil Factor to confess. He came up with a classic: The mistaken belief that a backup WITH CHECKSUM guaranteed a good backup that could be restored, and the ensuing disaster.  Read more...
By Additional Articles 2012/02/02 | Source: SimpleTalk | Category: simple-talk series
Rating:  Rate this |   Briefcase | 4,903 reads

Detecting Changes to a Table

Discussing various techniques for detecting changes to a Table.  Read more...
By Lawrence Moore 2011/05/23 | Source: SQLServerCentral.com | Category: checksum
Rating: |  Discuss |   Briefcase | 10,748 reads

Turn on CHECKSUM after an upgrade

When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.  Read more...
By David Baffaleuf 2010/07/20 | Source: SQLServerCentral.com | Category: page_verfify
Rating: |  Discuss |   Briefcase | 6,870 reads

Poor Man's Table Difference

Given a tablename and other parameters, this procedure will return a table made of foreign keys and a checksum for each  Read more...
By klini 2010/05/06 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 1,961 reads

checksum

By Steve Jones 2009/02/13 | Category: checksum
Rating: (not yet rated) |  Discuss |   Briefcase | 3,676 reads

Using the CheckSum Function - SQL School Video

There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.  Read more...
By Brian Knight 2008/12/18 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,829 reads
   Items 1 to 9 of 9   
 
Tags
t-sql (5)    
hashbytes (3)    
rowversion (3)    
sql server (3)    
binary_checksum (2)    
change detection (2)    
conflict resolution (2)    
checksum_agg (1)    
indexes (1)    
migration (1)    
page_verfify (1)    
replication (1)    
simple-talk series (1)    
timestamp (1)    
torn_page_detection (1)    
triggers (1)    
video (1)