4 ms·
Quickly Compare Data in Two Tables Using CHECKSUM and CHECKSUM_AGG https://sqlundercover.com/2018/12/18/quickly-compare-data-in-two-tables-using-checksum-and-c
by frhack 3y ago
Quickly Compare Data in Two Tables Using CHECKSUM and CHECKSUM_AGG
https://sqlundercover.com/2018/12/18/quickly-compare-data-in-two-tables-using-checksum-and-checksum_agg/ https://sqlundercover.com/2018/12/18/quickly-compare-data-in...
- amtamt 3y agochecksum 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 https://www.postgresql.org/docs/current/features.html and https://en.wikipedia.org/wiki/SQL:2023#New_features https://en.wikipedia.org/wiki/SQL:2023#New_features.
- LeonB 3y agoI 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_hashbytes.html#solution-for-versions-less-than-sql-server-2016 https://til.secretgeek.net/sql_server/bulk_comparison_with_h...