Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

CHECKSUM Expand / Collapse
Author
Message
Posted Monday, September 07, 2009 4:19 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, April 13, 2014 9:51 PM
Points: 4,570, Visits: 8,315
Marcin Gol [SQL Server MVP] (9/7/2009)
Sergiy (9/7/2009)
Marcin Gol [SQL Server MVP] (9/7/2009)
Sergiy - the paragraph you mentioned change nothing. hash is a hash - and for a given string should always return the same value. did you try to run his query on your sql ?

You probably did not reach the last sentence of the paragraph.


i read it but i feel that we don't understand each other

my version: for a given string we should always receive same hash, did i say that hash is unique? nope.

maybe other question is right here ... does the implemantion of checksum function has changed over the time ? (sql 2000 -> 2008?); if don't why im getting other values of checksum than Zahran ?


It actually returns the same hash value for unchanged original value.
Is it any different on you machine?

And the topic was actually about uniqueness problem. My reference was about it.
Post #783936
Posted Tuesday, September 08, 2009 2:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 04, 2012 12:23 PM
Points: 2,087, Visits: 3,932
Marcin Gol [SQL Server MVP] (9/7/2009)
maybe other question is right here ... does the implemantion of checksum function has changed over the time ? (sql 2000 -> 2008?); if don't why im getting other values of checksum than Zahran ?

I get the same return values on SQL Server 2008.



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #784056
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse