SQL Server: ways to compare data between large tables and view
Need to compare data between large tables and views. Databases are on different servers. One has tables, the other has views derived from the 3rd database on the same server.
EXCEPT on original tables and views takes forever.
Thank you in advance.
Microsoft SQL Server 2008Microsoft SQL ServerMicrosoft SQL Server 2005