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

I am just giving my suggestions.  My opinion, I would upgrade the server to have the same or more resources than the current server.  I would also do database administration,

In...

If it was me, I would want the game server to have maximum uptime.  Downtime means unhappy customers, no?

If I was a customer for a game and the server went...

Zip file is literally the same concern I had initially - I don't download files from unknown sources.

Posting the DDL to the forum will get you better responses to your...

I can't speak to all of this as I don't use replication and haven't set it up or seen that problem before, but I am curious what you mean by...

I have not downloaded the files (as I don't generally download files from random people on the internet), but I don't think you are going to get much response with...