I know i Will get a lot of different answer to this question and it is okay, but i Will give the points to the fastest "rebuild".
If you have a table with 400 000 000 records with aproximate 15-20 columns of "normal" datatypes (no bit, tinyint, smallint, etc), how fast have you rebuilt an index with 3-4 kolumns online.
Please specify how your system is configured and some details about the table.
Why i am asking? I am invited by Microsoft to demonstrate performance of SQL server fasttrack dwh at an event here in Sweden and want some performance compare.
I Will give you may figures later.