I have altered the question to say "easiest way" and I tend to agree with Hugo that a real table would have other constraints on it. However making a copy...

Monitoring is looking for something wrong to happen, auditing is determining what happened, and then where you can fix it.

I hope that the person I wrote about is the minority...

No real advantage.

You really should consider indexing the heaps. A clustered index is how SQL Server is optimized to work, so create one on each table. Is there a reason not to...

What is the maximum memory setting? You might increase that, and then look at the ETL queries and see if they can be indexed better. Check the missing index DMV,...

Do you mean that you want the same number of rows in A as in B for each ID?

An outer join will help you figure out which rows are not...

Please post in the correct forum. Moved to SSIS.

The 1252 should be the length of data selected.

You need to look through your data. It's possible that you have some rows...

You need some way to determine what's changed.

I might actually write triggers on the first copy that moves inserts and updates to a second database. Then the deletes won't affect...

You want to pivot the data. Search for that.

Please don't cross post.

You have to write this again.

You have table valued parameters in 2008, not 2005.

The classic answer is "it depends".

I'm sure you see queries that consume more CPU and eat up more resources. If all users run those, the server can be overloaded, but...

Try this: http://sqlblog.com/blogs/linchi_shea/archive/2007/02/26/maintain-database-partial-availability.aspx

Other objects, views, procedures, etc. aren't automatically transferred. You need to rewrite these in T-SQL from whatever variant of SQL Postgres uses.

Do you mean:

- backup db 1

- delete old backup of db 1

- backup db 2

- delete old backup of db 2

...

The way the maintenance plans work, this doesn't happen. Most...