>>You have one big table with cca 140 indexes. Two discs for data and indexes is good choice.
>
>Ok, I am not sure I can justify that but I will take note of it.
>
>>PS: If you have MSSQL 2012 Enterprise, the partition table can be next choice.
>
>Is this also viable for 2014?
Partition table is available since MSSQL 2008R2 Enterprise
Table in memeory is available since MSSQL 2014 Enterprise
MartinaJ