One thing to keep in mind with the SSIS route (which Brian and Chandan are right is the standard tool here): SSIS works great for the initial build but maintaining...

Just to add, OFSK targets last page latch contention which is specifically the pattern you get with identity columns. Your current PK (2 int + 1 bigint) probably scatters inserts...

The UNION ALL error you're getting is almost certainly because your original query used SELECT * which pulls columns from all three joined tables. Steve's rewrite uses SELECT p.* which...

Stan, your thinking about the hub layer is the right direction and honestly what we see work best in practice. Instead of having a dozen internal apps each making their...