Get better soon. Emergency surgery is no fun at all.

Yep, that was my thought. Hence the question.

Are you seeing messages in the errorlog file about IO Frozen and IO Thawed?

Then dual socket 8 core machines are the best they need to buy, and there's no reason to go above 128 Gigs of RAM on Standard or BI edition. ...

With standard edition you are capped at 16 cores. It won't use any more than that.

Unless you've got some business rule that says that customer data needs to be physically isolated from other customer data for some reason, I think you need to take a...

Giova (7/7/2014)

---

I think these queries need to be tuned but at the moment the customer want not spend on this. At the moment I can only try to fully describe...

I'm going to pretty much echo and agree with everything that Gail said about parallelism, MAXDOP and CXPACKET.

CXPACKET is NEVER the problem. You need to look at the other...

What's the end goal here?

You would need to research the encryption algorithm that Microsoft used in SQL 2000 and build your own decryption process and have it decrypt the values then reencrypt the values...

Sorry I wasn't very clear. There are four file groups all residing on one RAID10 volume:

Primary: one file

Filegroup2: forty files

Filegroup3: forty files

Filegroup 4: one file

I was told that this was...

There's no need for 80 database files for a user database. This gives you no performance benefit at all. All you are doing is making the database very...

You may need to restore the master, model, and msdb databases then the user databases, but yes you should be able to recovery with just an OS snapshot.