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

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