ScottPletcher you ought to share that here and maybe one of us (or more than one of us) can help you complete that code. That might also help this individual...

Okay you need to explain that a bit more clearly -- an Index is an object applied to a table.

So yes you can sort of merge two indexes into one...

Hey if you need to hire someone to figure this out for you I am currently available and I would not even charge you an arm and a leg to...

I concur with Jeff Moden and frederico_fons in that without presenting the entire problem in detail upfront you are short changing yourself on a quality solution. The less you provide...

Okay I cannot say if what I am outlining will help much but I have found it is better to Keep It Simple and Smart (K.I.S.S.) rather than getting complex...

NVM

• This reply was modified 8 months ago by  Dennis Jensen.

I know some folks will say they can help you but only if you supply the Plan Metrics so you might consider adding that in since you do not want...

Okay while that might be doable -- dang it hurts the head to think about what will actually happen.

I mean, usually with an Availability Group, one is usually sychronizing them...

• This reply was modified 1 year ago by  Dennis Jensen.

Okay let us examine more closely what you provided cleaning it up just a little as unlike some junk I get it was relatively nicely format:

SELECT DISTINCT
...

• This reply was modified 1 year ago by  Dennis Jensen.

Well we run two AG groups although we do not cross-talk between them as one is for Preprod and the other is Prod. However, in our Prod AG we have 3...

Okay Mark your description is a bit confusing but here is what I understand so far and correct me if I am wrong:

1. 4 Databases 1, 2, 3, 4
2. 2...

• This reply was modified 1 year ago by  Dennis Jensen.

Okay to clarify what you seem to be saying:

1. You have a 2 Node Availability group with a primary and a secondary (failover) server (the last is an assumption)
2. You...

Thank you very much ratbak I had gone to that site to try and find the answer figuring someone might have asked it already but my searches were fruitless as...

• This reply was modified 1 year, 1 month ago by  Dennis Jensen.

Ah much thanks ScottPletcher I figured it was something I was just overlooking. That did the trick.

Thanks for ScottPletcher but now I am running into another issue that I am not sure why.  I have two tables, first one is the Primary table and the other...

• This reply was modified 1 year, 1 month ago by  Dennis Jensen.
• This reply was modified 1 year, 1 month ago by  Dennis Jensen.