|
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?
|
|
|
A very interesting topic
|
|
|
Good video, thanks.
|
|
|
I love these nuggets of information!
|
|
|
Should include if capital letters generate diferent value.
|
|
|
I never knew about this. I can see a lot of use for it. Thank you for providing this video.
|
|
|
ok and great i wish the display could be larger and clearer
|
|
|
zooming in the screen really assists in seeing what is being discussed.
|
|
|
Another great short segment from Brian.
|
|
|
Very good explanation - Thanks!
|
|
|
wonderful, clear and concise and good examples used
|
|
|
Good... i come to know new concept... Thanks!!
-R
|
|
|
Thanks for the work you guys do! Keep up the good work!
|
|
|
very useful.
|
|
|
It's very good.
|
|
|
Very helpful and useful video
|
|
|
greate
|
|
|
very useful, cheers
|
|
|
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.
|
|
|
Good Tip
|
|
|
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.
|
|
|
I was looking for a description of how checksum works, vs. just an example of its usage. I can deduce how it works after reviewing the video. Just took me a little longer, otherwise it was a nice little video. Thank you.
|
|
Jeff Benedict on
6/15/2011
Great.. opens new thoughts on comparison
|
|
|
Excelent video!! tks!!
|
|
|
Dig Brian Knight, he demonstrates well and clearly. No room for questions or afterthought. As a self trained BI Developer his input is of great value to me.
Shot Brian for the hard work!
|
|
|
Didn't get the Why aspect for using the checksum. Maybe to pass in a WCF collection that they validate on their side?
|
|
|
you should use extream caution when implementing the checksum for row uniqueness. I have ran into issues when two totally differnet rows produce the same checksome.
|
|
|
superb....!!!
|
|
|
Pretty good uses in the old day's for checksum, but with sql 05+ I have been using hashbytes to get a unique value in slowly changing dimensions and updateable tables.
|
|
|
Good and concise explanation with nice, simple examples.
|
|
|
Good quick summary.
|
|
|
Great introduction to a feature I had not considered before. Good trick to add to my bag.
|
|
|
What about NULL values? How do those affect the CHECKSUM function?
|
|
Sara Karasik on
6/15/2011
Fantastic! Easy to use, and useful
|
|
|
Brian, thanks for the video, however I think it's important to let your viewers know that the rate of collisions is actually a lot higher than many would think.
|
|
|
Thanks!
|
|
|
going to use tomorrow ;-)
|
|
|
awesome
|
|
|
a good tip
|
|
|
was useful thanx
|
|
|
Where can we get the cecksum function from?
|
|
|
in the video you mention it works most of the time. when does this not work?
|
|
|
Wish I understood better how to use the outcome.
|
|
|
The combination of a unique key (say a surrogate key) plus the checksum gives as close to 100% guarantee of uniqueness on large datasets as one typically needs for datawarehouse incremental change/add/delete functions, I've found.
|
|
|
good
|
|
|
how can it be all the columns if I have identity column in the table?
|
|
|
it was nice.. I learnt this in minutes...I was not knowing this feature. Thanks for this nice training.
|
|
Maurice Ivory on
11/9/2011
This will be very helpful for me in the future.
|