ScottPletcher (10/17/2014)

---

With that many rows, you'll probably want to consider other, more efficient methods of comparing tables.

For example, change tracking would allow you to determine the rows in each table that have been modified (DELETE / INSERT / UPDATE) since the last time you compared the tables. That should drastically reduce the number of rows you have to compare. You could then use standard EXCEPT | INTERSECT logic to determine row differences.