Clustering addresses specific requirements. It works well for some people, and one of the reasons it works well is the restrictions on hardware and setup.

It mirrors an instance. Database Mirroring...

PIVOT is a unique solution. Thanks for that.

However, is there a reason this shouldn't be done on a client? Would seem that as this scales, you're using server resources for...

Scale Out is hard, and it's mostly architectural.

You want to spend a few minutes on it early, thinking about where you could separate out pieces of data to another server...

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...