SQLServerCentral.com Articles tagged checksum

HASHBYTES: Is CHECKSUM really required?

Wed, 27 Mar 2013 06:00:00 UT

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.

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

Tue, 19 Feb 2013 07:00:00 UT

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.

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

Tue, 12 Feb 2013 07:00:00 UT

Confessions of a DBA: My Worst Mistake

Thu, 02 Feb 2012 07:00:00 UT

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.

Detecting Changes to a Table

Mon, 23 May 2011 06:00:00 UT

Discussing various techniques for detecting changes to a Table.

Turn on CHECKSUM after an upgrade

Tue, 20 Jul 2010 06:00:00 UT

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.

Using the CheckSum Function - SQL School Video

Thu, 18 Dec 2008 07:00:00 UT

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.