SQL Server 2017

Creating Clustered Columnstore Indexes everywhere

by

In this post I discuss creating Clustered Columnstore Indexes everywhere. In other words, which clustered columnstore indexes you can create depending on your SQL Server version. Because in a previous post I mentioned I could create clustered columnstore indexes in SQL Server 2019 regardless of the database compatibility level. To clarify, it appears you can … Read more

Adding R Services to an existing SQL Server instance on Windows Server Core

by

Previously, I have had issues when I’ve added R Services to an existing SQL Server instance on Windows Server core. So, I thought this post would help others. To be thorough, I have checked this on two separate combinations of Windows Server Core and SQL Server. Firstly, a custom Windows Server 2016 and SQL Server … Read more