In SQL Server 2014 there were a number of restrictions on memory-optimized tables: you couldn't alter their structure after they were created; many SQL operators weren't supported (Outer Joins, ...

Complexity: In SQL server’s data has to fit into tables anyhow. If your data doesn’t fit into tables, you need to design your database structure that will be complex and, again, difficult to ...