If you are trying to determine which rows are different between two sets, the usual method is to create a query comparing table1.Column1 != table2.Column1 but this doesn’t check for rows where one of these columns is null. isnull(table1.Column1,-1) != isnull(table2.Column1,-1) might seem like a good way to compare nullable columns – but the performance […]
Finding changed rows in SQL Server using INTERSECT, ISNULL or COALESCE and performance
