Indexes can't be created explicitly on table variables, and no statistics are kept on table variables. Starting with SQL [!INCLUDEsssql14-md], new syntax was introduced which allows you to create ...

Check perfmon to see if maybe the SQL server is just totally out of memory. There should be no logical difference between @table and #table, but the second actually creates a database object while ...

SQL Server 2014 In-Memory OLTP introduces two new widely advertised kinds of database objects: memory-optimized tables for efficient data access, and natively compiled stored procedures for efficient ...