Pro Members, SQL Server, Standard Members

Exploring OLTP in SQL Server 2019 (Part 2)

by Joydip Kanjilal

Enabling In-Memory OLTP in new and existing databases To create a new database and enable In-Memory OLTP in it, you can use the following script: CREATE DATABASE DemoOLTPDB ON PRIMARY ( NAME = DemoOLTPDB_data, FILENAME = ‘D:dataDemoOLTPDB.mdf’, size=500MB ), FILEGROUP DemoOLTPDB_IMOLTP_FG CONTAINS MEMORY_OPTIMIZED_DATA ( NAME = DemoOLTPDB_FG_Container, FILENAME = ‘D:dataDemoOLTPDB_FG_Container’ ) LOG ON ( NAME = ExamBook762Ch3_IMOLTP_log, FILENAME = ‘D:dataDemoOLTPDB_log.ldf’,…

This content is for Pro, Pro Member, Pro Member Annual – Fall Sale, Pro Member Monthly – Fall Sale, Standard, Standard Member, Standard Member Annual – Fall Sale, and Standard Member Monthly – Fall Sale members only.
Register
Already a member? Log in here
Author: Joydip KanjilalJoydip Kanjilal is a Microsoft Most Valuable Professional (MVP) in ASP.Net, as well as a speaker and the author of several books and articles. He received the prestigious MVP award at ASP.Net for 2007, 2008, 2009, 2010, 2011, and 2012. He has more than 20 years of industry experience in IT, with more than 16 years in Microsoft .Net and its related technologies. He has been selected as MSDN Featured Developer of the Fortnight (MSDN) and as Community Credit Winner several times. He is the author of eight books and more than 500 articles. He was a speaker at the reputed Spark IT 2010 event and at the reputed Dr. Dobb’s Conference 2014 in Bangalore. He's also worked as a judge for the Jolt Awards at Dr. Dobb's Journal. He is also a regular speaker at SSWUG Virtual Conference.

Comments are closed.