>>Partition table is available since MSSQL 2008R2 Enterprise
>>Table in memeory is available since MSSQL 2014 Enterprise
>
>Table in memory would certainly help for the queries. But, for writes, this would still require to update on disk, after memory would have been updated.
>

No, Table in memory is faster (2x-3x) for writing than standard table, because use another engine.

MartinaJ