Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the data in the warehouse is different from the incoming source data. One method to do this is to create a SQL Server CHECKSUM column in the data warehouse table and another on the incoming table data. By creating a checksum you can compare the checksum value in the data warehouse tables to the checksum value in your staging table. If the values are different only then do you need to modify the data warehouse table.
For example, this script calculates a checksum column on the DimGeography table using all columns except [GeographyKey] in the AdventureWorkDW sample database.

The post SQL Server Checksum appeared first on Derek E Wilson - Blog.