Forum Discussion

Anuradha Banerjee's avatar
Anuradha Banerjee
Copper Contributor
Sep 21, 2017

SQL Server 2016:In memory optimization of partitioned table

Hi,

Is it possible for a in memory optimized table to have partitions? If yes, can you show an example of how it can be achieved. I have seen examples of how it can be done using a hold/cold/staging table.

https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/application-pattern-for-partitioning-memory-optimized-tables

But I am looking for an example where the whole thing can be achieved using a single table.

 

Thanks,

Anu

  • Allen's avatar
    Allen
    Icon for Community Manager rankCommunity Manager

    Anuradha Banerjee

     

    I have moved your post to the SQL Server discussion board, someone here should be able to assist with your query.

Resources