Hacker News Reader

Quickly Compare Data in Two Tables Using CHECKSUM and CHECKSUM_AGG

https://sqlundercover.com/2018/12/18/quickly-compare-data-in...

checksum and checksum_agg do not work for all data items, at least for SQL server "Noncomparable data types" for checksum and "null" for checksum_agg are show stopper.

Also, checksum/ checksum_agg do not seem like SQL standard functions. referring https://www.postgresql.org/docs/current/features.html and https://en.wikipedia.org/wiki/SQL:2023#New_features.

I remember casting some types to varbinary and then using fn_repl_hash_binary() to generate the hashes.

And by “remember” I mean I wrote it down here so that I wouldn’t have to - https://til.secretgeek.net/sql_server/bulk_comparison_with_h...

Reply on news.ycombinator.com