I'm so sorry to post duplicate messages and cause the confusion. but John's link points to my other topic "How to switch data online". So let's discuss just talk about...

Thank you Robert!

I will try max degree of parallelism Option. Suppose that will help:)

Thanks a lot for all of the help.

Now I have other candidates:

(3) use SQL Server Table Partitioning

(4) use 2 tables and one view as Robert Cary suggested

(5) use 3...

Hi Sturner:

Thanks for your reply.

Basically we might have more than 6TB data and several servers, each with 3TB disks. Does SQL server...