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

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

From the same SO link you provided, see the following link.  Within that, look for an "It-Depends" header.  The first paragraph of that section has to underlined n0t-so-obvious links that...

Here's an introduction to what you need to do...

https://www.sqlservercentral.com/articles/finding-%e2%80%9cactive%e2%80%9d-rows-for-the-previous-month-sql-spackle-1

If you need more detailed help, we'll need some "Readily Consumable Data".  Please see the first article in my signature...

Lordy... I can't believe they didn't use a cursor or while loop, according to another article that appeared today.