We have used VMWare in a couple of UAT implementations...

If you are a DBA, you can explain the fundamentals of database management, right?

In my experience...restore from backup!

I have never been able to recover a suspect database (unless the server only run out of log space)...

The only issue is, when the tape backup is performed, the directory is uncompressed and re-compressed on the tape which makes tape backups take longer.

Server admin guys yell at me...

My SQL 2008 servers are fine with AD groups...I assume you are running SP1?

Both applications are memory hungry. It's not a good idea for performance reasons mainly.

Both applications are memory hungry. It's not a good idea for performance reasons mainly.

Usually a problem if you haven't updated statistics and updated usage.

It's a good idea to rebuild all indexes to be sure.

Don't kill any dormant processes (only as a last resort). There is a reason SQL doesn't clean them up itself...

It looks to me that one your queries could be missing...

I think you are slightly off Michael.

This is from my experience, rather than theory (which you can google):

In a 32 bit OS, first of all SQL can only address a...

The only issues I have come across in 64 bit is that there are still some 32 bit components (such as legacy DTS) as well as the Microsoft driver for...

I'm not sure I get your point Michael.

I guess, in simplicity SQL cannot address more than 2Gb memory (in 32 bit OS). AWE is in effect tricking SQL Server to...

We used DTS in SQL 2005. It works fine, but you need to make changes to the stored procedures.

I thought there was a Sybase import/conversion utility in SQL 2008?

You can do the same with a user. Just create a new login in SQL Server and GRANT execute on the desired stored procedures.

I'm not sure what you mean...SQL can address more than 4Gb with AWE (not without caveats).

My point is, most people will only run SQL on the server. If you have...