>>>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.
>
It *can* be, depending on the persistence model being used (and other factors).