@alzdba - I found an issue with using the Checksum for the equal compare. I have 2 differing rows that produce the same checksum. They have...

@dant12 - I created a console app based on your code. However, I commented out the final updated back to SQL. I'm was only concerned about...

Thanks for the code. Working on getting a copy of VS2010 to test it out. We're still old school around here using 2005.

No, I haven't tried parallel processing. If you have some sample code, I'd like to try it.

Yes, I am able to use .Net. I've tried a...

ALZDBA (11/30/2010)

---

You're getting the arithmatic overflow, because checksum generates:

declare @a int, @b-2 int, @C int

select @a=checksum(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16)

, @b-2=checksum(10,2,3,4,5,6,7,8,9,1,11,12,13,14,15,16)

,@c=checksum(14,2,3,4,5,6,7,8,9,10,11,12,13,1,15,16)

--...

ALZDBA (11/30/2010)

---

did you experiment with CheckSum peristed ( and indexed ) computed columns to detect perfect matches quickly ?

, RwCheckSum as checksum(col1, col2, col3, col4, col5,...

Thank you.

That is what I was thinking but wasn't sure how to tell if an "update is place" was actually happening. Is there any way to tell,...