Search – talk-data.com

Title & Speakers	Event
Memory-Optimized Data Structures in SQL Server by Ed Pollack 2023-10-20 · 15:00 With each version of SQL Server, more features become available that allow for data or metadata to reside in memory. These improvements can greatly reduce contention, improve query performance, and reduce the computational overhead of frequently executed T-SQL. This session discusses different features that allow for the use of memory-optimized data and the ideal use-cases for each. Topics include: Memory-optimized tables Natively-compiled stored procedures • Memory-optimized TempDB metadata Memory-optimized table variables Memory-optimized table-valued parameters Data durability And more! Effective use of memory-optimized data structures can greatly reduce locking, latching, blocking, and other common hallmarks of OLTP contention. This session will help you take control of your most critical and time-sensitive transactional processes by taking full advantage of memory-optimized data in SQL Server!	Memory-Optimized Data Structures in SQL Server by Ed Pollack

With each version of SQL Server, more features become available that allow for data or metadata to reside in memory. These improvements can greatly reduce contention, improve query performance, and reduce the computational overhead of frequently executed T-SQL. This session discusses different features that allow for the use of memory-optimized data and the ideal use-cases for each. Topics include:

Memory-optimized tables
Natively-compiled stored procedures • Memory-optimized TempDB metadata
Memory-optimized table variables
Memory-optimized table-valued parameters
Data durability
And more!

Effective use of memory-optimized data structures can greatly reduce locking, latching, blocking, and other common hallmarks of OLTP contention. This session will help you take control of your most critical and time-sensitive transactional processes by taking full advantage of memory-optimized data in SQL Server!

Activities & events