Learn the differences, benefits, and drawbacks of using temporary tables or table variables in T-SQL stored procedures, and how to optimize performance.

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 ...

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 ...