Merging two large tables physically in SQL Server 2014
going to take a while on 3 billion records but this is a query

select tableB.* 
from tableB 
left join tableA 
on tableA.ID = tableB.ID 
where tableA.ID is null