Maximizing Performance with Memory-Optimized Table Variables

Jared Poche

Table variables have a bad reputation, but memory– table variables can help us optimize the performance of our SQL Server procedures in several scenarios.

In this session, I will discuss and provide examples where memory-optimized table variables are a huge win for our database and application. We will discuss batched stored procedures, tempdb contention, the Halloween problem, and an improvement from intelligent query processing. We will also discuss issues that can arise with memory optimized table variables and how best to mitigate them. This session should be especially helpful to engineers and administrators with high throughput OLTP systems.