If anyone want to dive deeper into this subject -- try partitioning on Columnstore. It's a rare situation where you create table once and in full size. Normally you have...
I was making my own experiments with this on a very busy server in fact. Neither XML nor delimited string of data produce optimal results. The best was the long...