

Walk-Through of the Installing the Samples When installing the AdventureWorks2012 sample database I placed the DATA file on the C drive and the LOG file on the E drive. I have also allocated 4 GB of memory and 4 processors to this virtual machine to get this sample to work. The virtual machine has been set up with two virtual hard drives, where one is used for the C drive and the other for the E drive. On this machine I created a VMware virtual machine. I will be using my laptop that has 8 GB of memory and an Intel I7 Q740 processor, with a single disk drive spinning at 7200 RPM. Prior to walking though installing the new In-Memory samples let me explain the environment I will be using for installing and testing the samples.
#Adventureworks2012 oltp how to
The word document explains how to install and use the samples and the SQLCMD script upgrades the AdventureWorks2012 databases to use In-Memory tables, and then creates some sample tables and stored procedures.
#Adventureworks2012 oltp zip file
When you download the samples from this location there will be a 46K zip file that contains a Word document and a SQLCMD script. They are available on CodePlex at the following location: I’m sure you all want to know first and foremost where you can get these new samples. How You Can Get the New Samples, and Where You Should Start? If you haven’t yet looked into the new In-Memory OLTP feature in SQL Server 2014 CTP2 then possibly you should consider downloading SQL Server 2014 CTP2 and these samples to better understand this new performance related feature that is coming out in the next release of SQL Server. In this article I will be exploring and explaining using these new samples.

On November 4 th, Microsoft released a new set of samples targeted at In-Memory OTLP tables in SQL Server 2014.
