As a quick check before disabling the firewall, what about if you log into the SSRS server and try uploading from the server itself? That SHOULD bypass the firewall.

Since you...

First step - check the logs. The Windows logs, the SQL logs, and most importantly the SSRS logs.

With what you said, there is nothing for us to go on. The...

Why bother storing something that you can calculate out when you query the data?

What I mean is your table should have only the required data and then build views to...

The below is entirely my opinion - feel free to ignore what I say.

If you are not running frequently at 100% CPU, then you are not having CPU pressure.

Having your...

First I want to say I've not used system versioned temporal tables before, but from reading about them, the below logic makes sense to me.

Step 1 though is to read...

If they are "kosher" login attempts as you say, then this sounds like users fat-fingering credentials. If this is the case, I would push back on the app writers and...

In SQL, I would avoid a loop at all costs. I would estimate that 90% (likely a lot higher) of the time you do not need a loop.

Now, my approach...

Without being in your environment, this is just guesswork, but my GUESS is that the server "Abcdef" is on a different domain than dev.com or possibly that server lost the...

Varchar(max) can hold more, but if you really need to store a huge amount of json data, it may make more sense to store it on disk and parse it...

Are you doing a reorg of all indexes followed by a rebuild of all indexes? I REALLY hope not as that is redundant.

But reasons it could be slow that come...

Probably a dumb suggestion, but do you get the error if you run the restore as sa? I KNOW you said permissions are good, but when the system gives me...

Just so I understand the issue:

LIVE system - 2 hours to do index maintenance

TEST system - 10 minutes using the backup of live that is restored nightly

TEST system - 2...

I used Dennis Jensen's code (as I could copy-paste to SSMS) then tweaked it to work in SSMS and give some results with ID and DueDate:

USE master
DECLARE...

To add to what Jeff (and you) said, I wouldn't throw technology at a problem unless you know that it is the solution. And if you don't know what the...

I am not sure what the "best" way to handle this is, but the approach we took was to set up a second job to watch for running jobs. It...