This is EXACTLY what I am trying to do, only by month rather than week. Did you ever get help with this?

Chris,

Did you have any luck installing more than 25 instances of SQL on your cluster?

We're looking at doing a major SQL consolidation effort next year I would like...

As long as you stay insde the same processor family (i.e. 7000's or 5000's) and don't try to mix (i.e. 5000 with 7000) you should be ok. With server...

Windows 2003 or 2008?

Integration Services (SSIS)

Correct shahgols, RAID 5 is Stripe set with parity.  In other words, all of the data is written across all the drives and you could loose one drive and not...

Thanks everyone for all of your help!

Just to give some more detail to my set up. Table1 should only have 1000 or so rows, however, during each insert I...

Thtanks for the responses!

If I forgot to mention that the DID column is an ID field. Therefore, if I do a select distinct on it it will return all...

I'm seperating the columns out due to the size of the database. This is more of a data warehouse than anything else. I'm not sure how to join the...