|
Home > Archive > MS SQL Server security > May 2005 > Page Checksums?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| DavidMA 2005-05-27, 3:23 am |
| 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
| |
| Jens Süßmeyer 2005-05-27, 3:23 am |
| 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@microso
ft.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
| |
| DavidMA 2005-05-27, 9:23 am |
| 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@microso
ft.com...
>
>
>
|
|
|
|
|