I used separate disks in order to partition my tables (the largest was 400GB). You will still get some gains even if your file groups are on the same disk,...

Yes, the SWITCH requires partitioning.

Linked Servers do allow separate db servers to connect to one another. Other approaches such as replication and log shipping are used to keep the data...

OK, so I think what you are saying is that you have a very large table that you need to report against, but you only need a relatively small amount...

Bill, this is great! I have been interested in Genetic Algorithms for quite some time, but I never thought of implementing them in T-SQL! Great stuff.

Yes, I agree that partitioning is very useful and should be strongly considered by anyone that is working with large data sets. I am using partitions and still find breaking...