High performance using ColumnStore and in memory OLTP

SQL Server 2016 R Services and SQL Server 2017 ML Services provide advanced analytical capabilities that can also be applied to optimized tables. In this section, we will walk you through comparisons on how to use R Services with:

• A table with a primary key
• A table with a clustered ColumnStore index
• A memory-optimized table
• A memory-optimized table with a clustered ColumnStore index

Note

For more optimization tips and tricks with SQL Server and machine learning, visit:https://azure.microsoft.com/en-us/blog/optimization-tips-and-tricks-on-azure-sql-server-for-machine-learning-services/

Testing rxLinMod performance on a table with a primary key

The following steps will test the performance of rxLinMod over 6,096,762 bits of data stored in a table with a primary key. This Air Flights data can be downloaded from https://packages.revolutionanalytics.com/datasets/AirOnTime2012.xdf and stored in C:/Program Files/Microsoft SQL Server/140/R_SERVER/library...