We need to see the index definitions as well.  It seems to me that the index definitions would need to be different to produce plans and stats that drastically...

If you could post the plans (note, please, not a picture of the plans, but the xml files), we might be able to provide insight. With just a description, I've...

I'd have to see the plans to understand what is happening. Compile variables, ANSI connection settings, these kinds of things can result in differences. There's no way to pick one...

You're asking buy versus build I assume. From what you're describing, I'd buy, or, more likely, pay for a service. Vendor management and Customer Relation Managers (CRM) systems are pretty...

Nah, we've used it to put individuals in a room with other individuals. No vendors needed, or wanted. The interaction was still extremely limited. There's just a level of.... something,...

Maybe it would be possible for the virtual event software to incorporate something like MS Teams and Zoom have for having a private chat with someone during a meeting....

I have to admit that I miss in-person events because, as good as they can be, discussions even on things like teams still don't have the "feel" and "serendipity"...

While just moving from Standard to Enterprise can result in differences in execution plans, you may also be seeing other things. Check the server settings. Stuff like: default ANSI connection...

Depending on the amount of data in the master data, I've done this all with scripts in source control. That assumes the master data is all just lookup information, 5...

I suppose if you have really good monitoring in place, you could use this approach everywhere. However, what I've found over the years is that some databases need a limit...

Thanks Rod. Yeah, you've hit the nail on the head. While I found the hybrid model put together by the conference to work pretty well. It still didn't get the...

Source control here will be your buddy. First, like Phil says, make darned sure every query is using the schema as a part of the query (honestly, this should be...

If you use the event auto_stats in Extended Events, you get the specific reason for the statistics update. This will let you differentiate between whatever is occurring automatically and...

Multi-Statement, Table Valued, User Defined Functions have a very useful acronym that is worth remembering:

EVIL

Yes, I know it doesn't match MSTVUDF. Doesn't mean I'm wrong.

A couple of points on this.

First, in the suggested solutions, you left off the schema from the tables. Always include the schema in tables referenced in the FROM criteria. It...