Page Checksums?

From: DavidMA (davidlisaa-news_at_yahoo.com)
Date: 05/27/05

  • Next message: Jens Süßmeyer: "Re: Page Checksums?" 
    Date: Thu, 26 May 2005 21:16:03 -0700

    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

  • Next message: Jens Süßmeyer: "Re: Page Checksums?"

    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)
    • Re: CHECKSUM() question
      ... which we need unique values to distinguish between the unique First and ... The Checksum does not guarantee unique values given two separate strings. ... Links for SQL Server Books Online: ...
      (microsoft.public.sqlserver.programming)