Post links that go to the wrong post because spam notifications are no longer considered to be posts and are not counted in...

All of the other folks have brought up great points on this thread and there's really nothing to add.  To emphasize, though...

1. Partitioning does not improve query performance and will...

What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums.  Apparently even Steve has zero pull with them.  Sorry...

What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums.  Apparently even Steve has zero pull with them.

Two short paragraphs...

Obvious question, why does this person have the ability to do this in prod in the first place, kill this and you resolve 99.9% of the issues

Put delete triggers...

From the article:

"Life rewards action, not intelligence. Many brilliant people talk themselves out of getting started, and being smart doesn't help very much without the courage to act. You can't...

• This reply was modified 1 year, 5 months ago by Jeff Moden.

At this point, I'd check to make sure that the code for the 3 views, the datatypes for the underlying tables, and the actual data in the tables matched on...

Later, I dropped and recreated the indexes. This resolved the issue.

My question is whether index fragmentation could have caused the database to go into suspect mode (Drive health check...

Have you tried simply clearing proc cache for the database and then running the identical query on both systems?  I ask because this is starting to smell like a simple...

Ok.  Thanks, Steve.

Setup a stored procedure to send the email and have the trigger...

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

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