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’,...

Control of Data Redundancy Ideally, the database approach stores each piece of data in a place in the database. In certain cases, there is still data redundancy to increase system performance. However, this redundancy is controlled as well as minimized through application programming by introducing the least amount of redundancy as much as possible in the database design. Data sharing...

This question came from a busy professional. My boss told me that she expects my work to be flawless when she checks it and I responded “okay” with a smile. She told me to stop smiling. How should I have reacted? This is a sticky situation. Don’t Judge If this is uncharacteristic of her, then she may be having a...

SQL Server has for long been Microsoft’s flagship database product. It has emerged one of the most popular Relational Database Management Systems (RDBMS) available in recent times. To meet the demands of the businesses and enterprises, many features have been added to the newer versions of SQL Server such as the In-Memory OLTP Engine. Support for OLTP was first introduced...

This question came from a job seeker. How do you work with someone who refuses to respond to emails because it creates a paper trail? The first rule of good business is to keep a paper trail of all official business interactions. It will save you much frustration and miscommunication. If someone is afraid of a “paper trail” – it...