Using the TSQL Checksum Function

Brian Knight introduces the checksum function and demonstrates how to use it to determine that a column or an entire row has changed.

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

Paula Hudson on 12/18/2008

The speaker spoke a little too rapidly, but I could keep up. Also, in a couple places at the beginning, the words he was saying were really run together, just for a bit. Don't know if that could be related to bandwidth on my end?

John O'Sullivan on 1/5/2009

A very interesting topic

Andrew Webster on 1/5/2009

Good video, thanks.

michael on 1/5/2009

I love these nuggets of information!

Carlos E. Mosquera on 1/5/2009

Should include if capital letters generate diferent value.

John Barone on 1/5/2009

I never knew about this. I can see a lot of use for it. Thank you for providing this video.

nyaknoabasi on 1/5/2009

ok and great i wish the display could be larger and clearer

Nancy Simmons on 1/6/2009

zooming in the screen really assists in seeing what is being discussed.

Ed Svastits on 1/6/2009

Another great short segment from Brian.

Jon on 1/6/2009

Very good explanation - Thanks!

Mickey on 1/25/2009

wonderful, clear and concise and good examples used

R on 2/1/2009

Good... i come to know new concept... Thanks!! -R

A. Faulkner on 2/12/2009

Thanks for the work you guys do! Keep up the good work!

Chris Helm on 2/13/2009

very useful.

ramdas on 2/17/2009

It's very good.

Scott Krell on 3/11/2009

Very helpful and useful video

hassan on 5/25/2009

greate

3EAA01C6D4 on 9/11/2009

very useful, cheers

D Arthur on 10/26/2009

There is also BINARY_CHECKSUM, which is case-sensitive for strings, and CHECKSUM_AGG which can detect changes in a table.

Daniel Gras on 10/26/2009

Curious about the rumors that checksum sometimes does not detect a change, in rare cases.

Andres on 12/29/2009

Good Tip

Sukhvinder on 5/13/2010

Brilliant thanks. I did not understand it on online help but you explained it so well that I understood it very well. Your videos are great and help so much. Please keep up the good work.