I'd also have a meeting with the 3rd party creators of the software and ask them to fix it.

As a bit of a sidebar, this is one of the many...

As Phil suggests, please provide the data in a readily consumable format instead of a graphic to help us help you.  See the first link in my signature line below...

I use those tools as a starting point for investigation and not as the truth.  Many times the end result of an investigation is modifying an existing index instead...

I'm going to advise some good caution here.  There are a ton of tools, including but not limited to SQL Server's built-in "missing indexes" tool but you should never just...

You can get the code for it in the "Resources" section at the following article, which explains how it works, as...

Thank you for the feedback.

When dealing with untrusted data, you'll need to use things like TRY_CONVERT().  If it fails, it will return a NULL.  Then you can go back to the original data and...

Jeff, The "url" link to the excellent article at the beginning of this discussion isn't working. I believe it should point to https://www.sqlservercentral.com/articles/hidden-rbar-triangular-joins, but only you have the ability...

"Bump" to check for missing posts at start of new page.

Heh... turned out to be SPAM... took that out.

It was great to see...

As someone who will turn 40 (Hex) in 2 months, I am in the same position. I love my current job and hope it is my last before I...

@jeff Moden for what it's worth, I saw your original post both before and after your follow-up, without issue. I am NOT missing a Jeff Moden post. That's unacceptable....

I so wish they'd fix the paging and the other incorrect "landing" for posts, etc.  "Bumping" my previous post so that page 2 would actually show up.

Perhaps us dinosaurs actually have a brighter future than you might think.  There seems to be a new trend away from the cloud.  It kind of started when Musk moved...

Thank You Jeff,

Let me read thru it, mess around with some data, I will get back with some data if I get hung up.

I really appreciate the info, Thank...