Product has been added to your cart.

5 – Memory-Optimized Table Variables

In the last module, we finished up by showing how Microsoft used In-Memory OLTP (Hekaton) technology in SQL Server 2019 to let TempDB’s system tables work faster. That’s an easy way to reduce latch wait times, but it’s not the only way: you can directly adopt In-Memory OLTP yourself by changing your temp tables to…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Fundamentals of TempDB
  7. 5 – Memory-Optimized Table Variables
In the last module, we finished up by showing how Microsoft used In-Memory OLTP (Hekaton) technology in SQL Server 2019 to let TempDB’s system tables work faster. That’s an easy way to reduce latch wait times, but it’s not the only way: you can directly adopt In-Memory OLTP yourself by changing your temp tables to...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}