SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of Brian Knight
Author:

Author Bio:
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.
Using the TSQL Checksum Function

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.

Video Information
Publish Date:
December 01, 2008
Length:
3:17
Skill Level:
100
Rating:
4.32 out of 5

After watching you should be able to answer these questions:
  1. What is the main reason to use the TSQL checksum function?

  2. The TSQL checksum function will work on which of the following?
You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
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



Must Be Logged In

References
Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions