This post has been republished via RSS; it originally appeared at: Channel 9.
Our man Jos is back again, and this time he is talking about memory optimizing temporary data structures. And true to form, Jos brings in the whiteboard and spends 35 minutes walking us through how to improve TempDB performance by leveraging some of the In-memory OLTP technologies.
No slides, just pure in-depth information. Enjoy.
Get started with memory optimizing temporary data structures: https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/21/improving-temp-table-and-table-variable-performance-using-memory-optimization/