Maximizing Performance with Memory-Optimized Table Variables - Jared Poche

Hosted By
DBA F.

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

DBA Fundamentals Group
See more events
DBA Fundamentals Group

No ratings yet
Online event
This event has passed
Maximizing Performance with Memory-Optimized Table Variables - Jared Poche