I've created a varbinary hash to check changes between 2 tables.
Here is the execution plan, I'm a bit stumped on the indexing, or indeed if there is a better way of writing this. https://www.brentozar.com/pastetheplan/?id=HkHmqoczm
The 2 columns in the join are the PK in the target and have a non clustered index on them in the source. The bit that bothers me is the spill to tempdb caused by the sort.