Normally EXCEPT or MINUS does a good enough job.

For full comparisons of MSSQL tables, I often use Visual Studio which has a Data Comparison tool that shows identical rows and differences between source and target.