Estimated plan can tell us a lot. Sure, actual plan tells you more, but just plucking the plan out of cache goes a long way.

This is very much an opinion question, so please take this answer as such.

Yeah, you need additional monitoring.

The basics are there, sure. The AWS console will tell you if the...

In order to have a history of queries, behaviors, what have you, on SQL Server, you have to set up monitoring. You either have to build it out yourself, or...

Never mind. I see you've asked this question in multiple locations. Please, don't do that. It just splits up the conversation. Let's all agree to meet at this one...

Like Jeff, I can't see anything.

I'd suggest looking at a process called PIVOT? Might help. Can't know. Just guessing.

Do you have access through the firewall for your IP address. That's the most likely thing. This is a very common problem, with MySQL, PostgreSQL and SQL Server on Azure....

Just remember, a view is nothing but a query (materialized views are a different discussion). As a query, is it better to write a specific query for a specific need,...

I searched through this, but it remains unclear to me, is there an index on ContainerTypeName? Preferably where that column is the leading column in the index so it's running...

Have you looked at the execution plan for the query in question? That's going to tell you a whole lot about how it's being executed, what resources are being used,...

Not sure I'd describe Tommy Flowers as a postal worker other than because of the name of the organisation he worked for.

True he worked for the General Post Office...

Instead of installing SQL Server locally for development, you might consider running it as a container. The advantages are, you can turn it on & off without mucking with services....

If there are no transactions, it will only show the older data. There isn't an automatic rest of pg_stats_statements. However, there is a command you can issue to reset it...

You've updated windows, have you updated SSMS and the underlying tools? If not, start there.

If you want more detailed answers, post the full set of code, and probably some of the structure as well.

HI FOLKS

ill go back and check the index's being used on both to ensure both the same (its the exact same query using exact same front end application) only...