1
source | link

I would recommend using Memory-Optimized Tables. 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

    Post Made Community Wiki by user126897