Not seeing your structure, it's hard to know what the issue might be. I'd break it down. Take the query down to it's component parts & rebuild them, one step...

Microsoft has a bunch of monitoring built in to the Azure portal. It's not the easiest to use, and seeing all your instances at once is a real pain. However,...

There is no precise guidance. A table could be as little as one column or as many as the max, 1024. However, in general, you'll probably see no more than...

I missed the link in my last post. Here it is.

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