There are times when we need to compare two tables and figure out if the data matches. I often see a number of ways of doing this suggested, most are quite slow and inefficient. I'd quite like to share a quick and slightly dirty way of doing this using the CHECKSUM and CHECKSUM_AGG functions. CHECKSUM()Just... Continue Reading →