OK, I'll bite... PFM???

The answer is that AS can definately impact the performance of a SQL instance, the inverse is, of course, also true.

Many people recommend running them on seperate servers, but it...

I don't know of any links right off hand, but I would certainly NOT expect there to be "massive" improvements.  Most of the improvements that you might expect from having...

As long as there is an appropriate trust relatioship between the two domains you should be able to add the remote domain\user, or the appropriate group, to the logins.

All the archive utility does is to copy the data files into a .cab file.  We have the same issue and instead of using the archive utiltity we just schedule...

I do agree with lowell's first suggestion however... 

I have to disagree with the name/value approach to inventory attributes.  This at first looks very flexible (and it is) but there are several critical flaws.  The first and foremost...

My first response is why in the world are you using guids on "all tables" for a primary key?

Assuming you have your reasons... The ROWGUIDCOL property doesn't really add much,...

An even better solution to this is Lumigent's Log Explorer.  I understand that LogPI does the same thing but I have used Log Explorer to recover from this kind of...

db_owner won't work if the database doesn't already exist on that instance of SQL Server.  In that case the user must be in the dbcreator fixed server role.

I don't understand the need to BCP the tables out to files and then script all the databases and jobs.

Doing a database backup includes the data as well as structures...

The only place we used VMWare was in our development and test areas.  It worked fine there.

For production it didn't make sense because our SQL boxes were already a "shared"...

I don't get it.  You have a start and an end date and you need to plot the hours between them?  But you haven't given any that you need to...

BTW, I can certainly understand needing to shrink a production database once in a while, but I don't generally include that as part of normal maintenance.  If you are in...

This depends largley on your I/O system and how it's configured, but even a horribly slow disk system should be able to accomplish this in just a few minutes.