To add to what everyone else has said, network performance could be a bottleneck too.  Those tables don't look like they hold that much data in terms of MB or...

I think my representation of SSIS was a bit off.  What I meant was that SSIS would be used for the data pull from source, the transform of the data...

Bruin's solution works with the exception that it doesn't capture error messages from the scripts.  But what you COULD do is a modified version of Bruin's script, but it does...

Personally, I agree with you Rod.  I think that report writing is more of a "business analyst" role than a DBA or DB Developer role.  BUT that being said, I...

I was just reading the error message as it says "The process encountered a deadlock and is retrying".  This is the expected behavior.

Now, as for long running blocking causing deadlocks,...

My opinion - I do 1 solution per folder in SSRS on a per-subfolder basis.

What I mean is if my SSRS layout is like:

home/

-- Inventoy/

-- invReport1.rdl

--invReprot2.rdl

-- Warehouse/

--WarehouseReport1.rdl

I would have 1...

I would review the logs.  See why it can't execute that stored procedure and possibly find a maintenance window where you can run sp_replrestart for a long period of time...

That sounds like your backups are encrypted. What certificate did you use to back up the database?  I expect you didn't restore that certificate onto the secondary system.

SSC actually has...

Had another thought on this - since you don't want to do updates on the SQL instance, why not look at putting it in Azure in a SQL Managed instance...

Looking at your tables, I don't see how you relate "Products" to an opportunity or order.

I WAS going to say that you could related them by ID on Products and...

It might run without issues for you, but it is not a supported configuration.  A windows update OR a SQL update could break the SQL instance on that server.

If it...

I see this posted on a lot of other sites and the solution is pretty easy - don't add HUGE columns to a nonclustered index.  You need to shrink the...

Another thing to note - parallel queries MAY not be what you actually want.  Depending on the query, it may not make sense for it to run in parallel.  I've...

Can they select multiple offices or fol_num's?  If so, then it gets a lot more challenging, but if not, then it should be something like this:

AND (OFFC_CODE...

Could you post the DDL for Opportunities as well?  You posted products twice and then orders.

But looking at that, your orders table has no way to related to products UNLESS...