You must be using some dynamic SQL for the process, and that dynamic script is built incorrectly.

This is the part you need to fix.

Find the records to delete in an aggregated  subquery and then join it back to the table:

 SELECT D.*
 --DELETE D
 FROM #partsDetails D
INNER JOIN (
SELECT MAX(partsDetailsId)...

Can you...

Check your file in a HEX viewer.

It starts with pretty interesting sequence.

@Sergiy Thank you so much for your help on updating the query to make creating the view possible. That small change to the where exists made all the difference. ...

its not a problem with Solawinds Orion...

Thing is - manages are appreciated for being effective on resolving critical situations. Preventing a crisis - not so much.

if nothing happens - your KPI stays low. Nothing to show...

"Don't fix if it ain't broken" - this is used far too often.

the bridge has to collapse for them to decide its time to replace those rusted bolts.

Queries like this against the data structured this way will always be prone to bad plans.

Some times statistics suggest optimizer to choose key lookup, some times it will be index...

I had a closer look at the query and I'm not surprised it's not performant.

First - what do you need the...

Are you sure you need that table at all?

Why wouldn't you try to create a view base on the same query you use to populate the table and then query...

i can add my logic to char, date time and bit columns, all at the same time:

ORDER...

I may not have had to rebuild them, but doing a full sample on the statistics definitely fixed the slowness.

Should I have to do a full sample on the...

There are some questions I'd like you to answer in order for me to help you.

1. Is there Customer Number or any other direct reference to  HDR in wspkgShipment ?

...

Why do you think you need rebuilding the indexes?