Re: Page Checksums?
From: DavidMA (davidlisaa-news_at_yahoo.com)
Date: 05/27/05
- Next message: Lionel Horn: "Prevent Adminstrator Group Access"
- Previous message: KIRAN MAHA PATRO: "GLOBAL GROUPS"
- In reply to: Jens Süßmeyer: "Re: Page Checksums?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 27 May 2005 06:29:02 -0700
Hello Jens,
Yes, I have seen that ability. However, I'm looking for a pre-calculated
checksum that's on ALL pages in the database.
Thanks for the response.
"Jens Süßmeyer" wrote:
> 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
>
>
>
- Next message: Lionel Horn: "Prevent Adminstrator Group Access"
- Previous message: KIRAN MAHA PATRO: "GLOBAL GROUPS"
- In reply to: Jens Süßmeyer: "Re: Page Checksums?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
