SQL Server 2016:In memory optimization of partitioned table

Highlighted
Occasional Visitor

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-par...

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

 

Thanks,

Anu

1 Reply
Highlighted

@Anuradha Banerjee

 

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