I would recommend using [Memory-Optimized Tables][1]. From what I understand, you don't need to preserve content on server reboot, so use then in non-persistent mode. They can often be 5-10 times faster than temp tables or table variables. - [piotr][2]


  [1]: https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/overview-and-usage-scenarios?view=sql-server-2017
  [2]: https://dba.stackexchange.com/users/177433/piotr