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

I agree with Joe on this one and would disagree with aaron.reese.  Parsing a string like that in SQL is going to be painful and adding more logic into the...

If you are getting the results you need, is there a reason to go with DISTINCT instead of GROUP BY?

If you absolutely need to remove the DISTINCT and replace it...

I can think of a few approaches, but my recommendation is to scrap that process and instead use stored procedures and have your code call the stored procedure instead.  This...

• This reply was modified 4 years, 1 months ago by Mr. Brian Gale. Reason: adding more info

What I am expecting is happening is that the datatype of BillingRateB is going to be something like VARCHAR and the value is something along the lines of '' or...