Apologies for the delay. the XLS is updated.

I think you can survive without knowing the business. Window setup, exchange, basic SQL admin, etc. don't need business knowledge. However they're then tactical, utility services.

If you want to be...

And show some work in what you think or have attempted.

Upper case before lower case (http://www.asciitable.com/), remember that we only had upper case way back when.

But do the QOD however you want. Some people want the points, maybe it's a...

The query shows "value1", not "Value1", which definitely depends on case sensitivity.

however, in any case, "value1" is less than "value2" and the others. Your example bends the rows into columns....

Actually if it's just 2 or 3 drives, implement RAID first. If a drive fails, you're in trouble. That's more important than moving stuff around.

2 RAID 1, keep a spare spinning in there. OS, data on one, Logs on the other.

Be nice to get 2 smaller drives for a small log array and go...

Look up UPDATETEXT. It is needed once you get above a certain size.

Mani is correct and you can sync them back up. Remember the USERS are in the database and this is completely separate from LOGINs, which are on the server....

I agree with Matt. Set the logs at their peak + pad, and leave them. There's no reason to shrink them. As you back them up (or checkpoint in simple...

Is performance worse than the old system?

I tend to agree with GSquared on the setup, though I'd check the cache on the SAN as well. For SQL you really want...

Ian, all you can do is document as best you can. If no one will pick up the slack to learn the older system, at least you've done something.

I'm trying...

Could it be IMPLICIT TRANSACTIONS set off for some connection?

The ROI or cost/benefit is something you have to determine, but I think there's something else to consider.

Is your company a risk taker?

Going with a new version early, means you're...

I've seen it both ways, and bragging doesn't always have anything to do with skill in my experience.

If someone is right, you might be annoyed by their bragging, but they're...