Whoof! 500 rows took 12 minutes? Honestly, that should be something that occurs in, at most, a few seconds.

Indexes may help (they can also add overhead to deletes as Frederico...

I'd start with the source. Here's Microsoft's take on upgrading SSRS. If you get stuck or need details, there are probably other resources that can help.

Testing will be your...

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