Tips for using temporary tables in SQL Server 2014 Consider using memory-optimized table variables instead of a traditional table variable to reduce tempdb use. SQL Server 2014 introduced In-Memory OLTP (In-Memory Optimization). In-Memory OLTP introduces the memory-optimized tables and the memory-optimized table type. A table variable created using a memory-optimized table type is a memory-optimized table variable. Memory-optimized table variables…
This content is for Pro, Pro Member, Pro Member Annual – Fall Sale, Pro Member Monthly – Fall Sale, Standard, Standard Member, Standard Member Annual – Fall Sale, and Standard Member Monthly – Fall Sale members only.
Register
Register
Already a member? Log in here