Also, I could be mistaken, but I am fairly confident that SQL Express handles up to 10 GB Databases, not 1 GB... and quick google confirmed this: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16

So, for a...

That should be all that is required. If they have browser permissions to the folder and file, it should work from the report server side of things. Where you MAY...

If I had to guess, I'd say your Oracle database connector isn't passing that information back. I'd look for a different database connector or see if you can configure the...

One thing before asking for faster disks - I would check if the disks are the bottleneck. I wouldn't try to fix a problem that doesn't exist.

Also, if the 200...

That could be the case Phil, but it also doesn't hurt to try it. I've seen weirder things! I wouldn't rule out the firewall until I have disabled it. The...

I mean, in the end the design is up to you, but for me, I don't see the point of storing the monthly and yearly values when you have the...

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