Re: Page Checksums?

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 05/27/05 

Date: Fri, 27 May 2005 07:41:02 +0200

Did you see the possibility to perform a checksum for each row ?

USE NORTHWIND
Select Checksum(*) from orders 

-- 
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"DavidMA" <davidlisaa-news@yahoo.com> schrieb im Newsbeitrag 
news:FB46F0CB-DEE5-4CC5-82E2-57CCD271270C@microsoft.com...
> Hello,
>
> Does SQL have any sort of checksum value attached to each 8K page or is
> there a feature we can turn on to enable such a checksum?  I'm trying to
> optimize our block data synchronization product specifically for SQL
> databases.  Our product is similar in technology to rsync.  We currently 
> use
> MD5 checksums which can be resource intensive, but are very accurate.  We
> are hoping that SQL already performed some checksum for each 8K page we
> could utilize to compare at a page level rather than generating our own 
> MD5
> checksums.  Please let me know if SQL has such a technology or if you
> have any suggestions.
>
> Thank you,
> David Aschmann

Relevant Pages

  • Re: CHECKSUM() question
    ... The HashBytes could be better, but it may consume a big hd space for the ... Is it better to use a Checksum combination such as the below? ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: CHECKSUM() question
    ... to join to your source table, then filter out the few collisions. ... This is very much like the example used in the BOL topic on CHECKSUM. ... Steve Kass once pointed out that HASHBYTES with MD5 for 300 million rows probably has a lower chance of collision than the the possibility that some bit will get randomly changed by some other influence. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: CHECKSUM() question
    ... Thanks for the replies but the Address table will not be part of the hash ... to join to your source table, then filter out the few collisions. ... This is very much like the example used in the BOL topic on CHECKSUM. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Strange Error
    ... I bring below SQL ... CHECKSUM_AGG returns the same checksum. ... Create table chs1 (idorder int,idpattern int,id_name int,yprice money) ...
    (microsoft.public.sqlserver.programming)
  • Page Checksums?
    ... Does SQL have any sort of checksum value attached to each 8K page or is ... Our product is similar in technology to rsync. ... MD5 checksums which can be resource intensive, ...
    (microsoft.public.sqlserver.security)