No idea how to ban someone, but I discovered...

Thanks Grant .. Can you suggest any tool to reduce the RTO?

The exact reason is the BC team want to reduce the RTO from 100 minutes we mentioned with...

If you have individual queries, and you can edit them, it...

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,...