Comparing Columns that can contain NULLS - is there a more elegant way?
You can use this approach from Paul White's article Undocumented Query Plans: Equality Comparisons

SELECT * 
FROM   A 
       INNER JOIN B 
         ON A.ID = B.ID 
            AND EXISTS(SELECT A.* 
                       EXCEPT 
                       SELECT B.*)