Maximizing Performance with Memory-Optimized Table Variables – Jared Poche (20250204)

Topic:

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.

Speaker:

Jared Poche began working with SQL Server as an instructor for certification classes and has a passion for teaching and performance troubleshooting. Jared spent 10 years providing customer support at Microsoft, most recently as a Sr. Support Escalation Engineer.

Jared is currently working as a database engineer for CommerceHub, blogs about his recent experiences, and speaks regularly at SQL Server events.

Links:

https://www.meetup.com/dba-fundamentals-group/events/304870909