SQL Server merge performance
Performing a merge against a table with 40 million rows takes many hours, on a database server with significant horsepower (64 GB memory, 16 cores).
SQL Merge Performance
Performing a merge against a table with 40M rows takes many hours, on a DB with significant horsepower (64GB memory, 16 cores).