thomashohner (9/30/2016)
The clustered index issue is hard as these are staging tables and the method we use from change tracking is prone to duplicate inserts sometimes. Its far from ideal. I will say that on the production system with the clustered index the original left join method was significantly faster than outer apply. For my environment and what i'm stuck with using it worked out very, very well.Thanks again to you and Lynn for taking time out of your day to look at my issue.
Dups won't affect that. You can create a clus index without it being explicitly declared as unique:
CREATE CLUSTERED INDEX index_name ON dbo.table_name ( ... ) WITH ( FILLFACTOR = ..., ) ON [filegroup];
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".