>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.
I use this concept in my framework. I load data dictionary tables in memory, and memory refreshes very rarely but upon some isolated changes in the DD occasionnally. Since I have done that, I have offloaded millions of hits towards SQL Server on a daily basis, increased the application performance.
I would see SQL Server achieving the same goals with tables in memory. I would certainly look for that.
However, this is tied to increasing more RAM. So, I would have to start writing more business cases.