So, go to this Microsoft web page. Scroll down to the section titled "RDBMS scalability and performance". Look at stuff like, row mode memory grant feedback and others. A...

• This reply was modified 5 years, 2 months ago by Grant Fritchey. Reason: Missed the link

We are trying to help.

You said the rows were different. Do you mean the row estimates are different? That's different and could be an indication of the difference between enterprise...

So, "server name could not be resolved" could be that you simply have the connection string wrong. However, more often is the fact that the IP address that the service...

Yes.

Does this mean it needs only 3200 rows but is ending up reading 1700000 rows to...

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

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