How to quickly compare 2 tables in SQL Server

This is the fastest way to compare 2 tables in SQL Server. Generate hash for both tables and see if it's the same.

SELECT checksum_agg(checksum (*)) FROM table1


Popular posts from this blog

Parse XML to dynamic object in C#

Parse XML to object model in C# using XSD utility