Unless you have a good reason, and understand it, you SHOULD NOT set a production database to simple mode.

The transaction log is essentially a copy of all the work done...

Please don't cross post.

I'd also recommend you rewrite this as

select x

from table a

inner join table b

on a.x = b.x

rather than your syntax. It's possible...

If you want to install it to test things, you can use a Virtual machine.

Sarang has some good advice. You want to determine which files are uploaded and which ones are not, and then programmatically handle the import.

You have to write a query that would find duplicates, and then decide (disable or delete) how to handle the duplicates. There's no way for us to know from which...

Memory Pressure - http://blogs.msdn.com/slavao/archive/2005/02/19/376714.aspx

I believe SQL Server will take a minimum amount and grow as needed.

I think you need to reference the server as well. DTSRun needs to know where the package is. Is it in the file system? In msdb?

Any locations you want to work in? You might click the "SQL Jobs" menu item as well.

I wouldn't think naming matters at all. Once it's compiled, it's resolved to internal compiled objects.

Can you list out which VMs you have and their allocations? What is the size of your physical machine?

There are issues with IOs especially with VMs. There is overhead and...

Before consolidating, you need to determine how many resources each of your current SQL Server instances are using. Knowing CPU usage and memory will be important for determining how to...

Do you have a backup from SQL Server, or did you stop the service and copy the .ndf at some point?

I would limit SQL Server, as Barry mentioned, though I'd make sure you at least give it 1-1.5GB at a minimum.

I don't know if you can use the English version on the German instance. I think the functionality is the same, perhaps there will be verbage changes of data.

Do you...