But, I have to tell you... even experts may have to try more than once and it frequently means running the code and measuring reads while comparing to execution...

In addition to all the stuff already mentioned, I'll add my book on query tuning (link in the signature, yeah, that one does cost money) gets into a lot of...

There is no one answer here. Personally, I have been pursuing knowledge of PostgreSQL in addition to SQL Server.

Why that and not something non-relational like MongoDB? Well, after studying a...

You'll want to update SSRS as well.

Also, you're at the magic inflection point, going past SQL Server 2014 (and do go past it, don't upgrade to 2014 and stop, not...

It's probably permissions though. That's the most common issue here.

I assume you're using something to automate the running of DBCC. When that something gets an error, have it send an email. That's it. So, how are you running DBCC?

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