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

Personally, I don't think my answer was any better than Steve's.  I think his answer was probably just as "correct" as mine.

But to address your concern about needing to add...

I agree with Steve here - why would you want to avoid the JOIN?  Put a good index on it and you should be good to go.

As an alternate approach...

My opinion - I think it really depends on what you need and what growth looks like.

I would personally put the data and log files on different disks if you...

With most SQL related things, I try to avoid the wizards.  I find that while they may work, it usually ends up making things in a way I don't want...

I agree with Grant here.  I find that MOST of the time when I think a Cursor is required, it is just that I have been doing too much .NET...

My understanding - even on a SAN the performance benefits may be lost.  The idea is to have it on separate physical disks.  once you start working with virtual disks,...