Sorry, not the person to help you with that. My C# skills are rusty to the point of immobility. Pretty sure there's a programming forum. I'd post there. Someone will...

I like option 2 for a bunch of reasons. If there is flexibility in what is included/not included in a location, that means that those values are not dependent on...

Happy to help. I'm always around here on the forums, or you can go to my blog. I also post the occasional video.

One recommendation...

So, your question is, can you make the four columns a primary key on one of the tables and then make a foreign key on the other table, right? The...

You can, although overall that sounds like a poor design. Name and address in both tables could lead to duplicate data and all sorts of issues.

I'd rather...

Not to mention NOLOCK everywhere, SELECT *... This is just a series of common code anti-patterns.

So you're moving 3.3 million rows filtered down after the JOINs, etc., from 120 million rows. In short, you're moving close to 3% of the data. That's actually not usually...

Best of all, post the actual execution plan so we can understand how the optimizer is resolving your query and how well the statistics match your data.

One immediate...

Capture the wait statistics during the backups to understand what your server is waiting on. That can very quickly narrow down what's going on. However, everyone has already pointed out...

As everyone else has already said, it's almost impossible to tell you what to do without knowing the structures you're dealing with (beyond the fact that it's temp tables) and...

Just verified it to be sure, the calling databases cardinality estimation is used in cross-database queries. So, yeah, when you change the database to the one that has a different...