Data Deduplication
A quick an easy deduplication - Uses a CTE and PARTITION clause to identify duplicates and delete them in a single statement.
Identify data that is not a member of both sets - Uses INTERSECT and EXCEPT to quickly produce a list of items from two identically structured sets that are not members of both.