When is the last time you updated the statistics on these tables?

No, but you can make one and actually keep track of history.  I have it show up in my "Morning Report".

Here's the table I created in my "DBA" database...

            
May 15, 2024 at 5:46 pm
            
#4421535

            
            
                                                
        

The irony is a company selling products that are software / code has a forum they support that has gotten buggier over time. This in some respects is a...

Bumping a post so that Greg's post above shows up.  It wasn't showing because it was the first post on a page, and that's just one of the problems on...

sales@ or marketing@ might get better traction. We have someone monitoring the webmaster email, but not 100% sure they'd do much more than send the emails to...

I sent this post on X:

https://twitter.com/rsterbal/status/1790436470181818647

Robert Sterbal 412-977-3526 call/text

@rsterbal

@redgate Who should I reach out to for issues with the https://sqlservercentral.com forums? Is there a place to post and follow...

😛 It IS a great litmus strip test.

What a...

Really Jeff Moden that would be interesting to read (or see) -- your proof in a presentation -- as I find that a rather interesting stance and would greatly...

Jeff Moden based on what ScottPletcher stated I do not see how one would end up with 2 Indexes as he did state you Drop one of the Indexes...

You don't actually have to drop both indexes.  You would, for example, often drop one index and modify the other one.

I've started on code to do this...

Bump post to get my message to show up because it's the first post on a new page. 🙁

@steve-2 :

I guess my question would be, what are the marketing stats for the site?  Perhaps a bit of understanding there would help us shape our requests...

As for scripts to "find duplicates", they have this new fangled thing called a "search engine". 😀

Try the following search and see what you come up with.  I haven't looked...

You don't actually have to drop both indexes.  You would, for example, often drop one index and modify the other one.

I've started on code to do this process but...