I have a script in existing SQL Server 2012 to delete old/expired sessions using partitioning. Data is moved from the source table to the staging table on basis of weekday partition and truncate operation is performed on the source table.
After migration to SQL Server 2016, partition and truncate is not supported on memory-optimized tables. What is the best solution to deal with this?