Hey Lowell!!!!

Great to see you out here in the wild.

Be a little cautious only on unique indexes when defining "used". The optimizer can actually reference a unique index in it's...

I'm not aware of this tool, so no real comment on it one way or the other.

However, the rules for any 3rd party solution for backups are very simple. Show...

To really get a grasp on SQL Server security, I'd suggest Denny Cherry's book on the topic. It's a little bit old at this point, but 90%+ of the...

Sometimes the ultimate fix is a rewrite of the queries to a more optimal pattern.

I'm just still not getting it.

So, let's try this. You can't have a dynamic join. You have to define a join. Period. To dynamically change whether or not you're joining...

This needs pretty detailed analysis, and I'm sorry, I've been busy with work. I'll try to get into it again as soon as I can.

Short answer, I suspect you're dealing...

I'm still not understanding what you're going for. Apologies.

However, I think what you want is two different LEFT JOINs to the two tables, then use COALESCE to get the column...

As you've defined it, a simple UNION query will get you what you want.

SELECT a.id_a as Id_Obj,
a.customer_a as Customer,
a.Name_a as Name
FROM dbo.db_a as a
UNION
SELECT b.id_b as Id_Obj,
b.customer_b...

So, you're not looking for tuning then, just management?

What about index compression? That's a huge win for some people, depending on your data. Also, columnstore indexes may, emphasize that word,...

I have admin access, so I went ahead and removed them for you.

Try...

If you want to, get a copy of SentryOne Plan Explorer. It's free. It has a way to anonymize the plans. Post those and no code will be visible.

Two things. First, the query is in the plan. I sure don't see anything that's even remotely proprietary, but if there's a concern, you should remove those from the post.

Second,...

I don't think 'interim table' is the correct term...

Did I misread your compatibility mode? If so, my bad, apologies. Yes, you can have the new compatibility mode enabled and then disable the new cardinality estimator.

As to the rest,...

I could try to guess at what you're going for, but instead, could you put the table names in with the tables. Show some of the relationships, primary & foreign...