Improvements of SAP (BW) System Copy

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Improvements-of-SAP-BW-System-Copy/ba-p/367937 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html For performing an r3load-based system copy of an SAP system you should use the SAP Software Provisioning Manager (SWPM). For a BW system it is mandatory to…


Required SQL Server patch for Columnstore

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Required-SQL-Server-patch-for-Columnstore/ba-p/367905 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html This week we increased the minimum required SQL Server 2014 patch for using the Columnstore with SAP BW. You should upgrade to: SQL Server 2014 SP1 Cumulative…


Columnstore Optimized Flat Cube in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Columnstore-Optimized-Flat-Cube-in-SAP-BW/ba-p/367884 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html With the general availability of SQL Server 2014, a new feature was released in SAP BW: The Columnstore Optimized Flat Cube. The prerequisites for the Flat Cube…


Concepts of SQL Server 2014 Columnstore

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Concepts-of-SQL-Server-2014-Columnstore/ba-p/367878 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html SQL Server 2014 delivers two different in-memory features, which are both fully integrated into the SQL Server Engine: In-Memory Optimized Data Warehouse This feature is optimized for…


SQL Server 2014 Columnstore: Released for SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/SQL-Server-2014-Columnstore-Released-for-SAP-BW/ba-p/367872 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html SAP generally released SQL Server 2014 for SAP NetWeaver two weeks ago as announced in http://blogs.msdn.com/b/saponsqlserver/archive/2015/03/11/sql-server-2014-now-released-by-sap-for-sap-netweaver-7-xx.aspx As of last week, the SQL Server 2014 In-Memory Optimized Columnstore…


SQL Server Column-Store for SAP BW: Status and Release Planning

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/SQL-Server-Column-Store-for-SAP-BW-Status-and-Release-Planning/ba-p/367854 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html This blog was originally released in January 2015. It contained the text of  SAP Note 2114876 – Release Planning SAP BW for SQL Server Columnstore. In the meanwhile,…


SQL Server Column-Store with SAP BW Aggregates

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/SQL-Server-Column-Store-with-SAP-BW-Aggregates/ba-p/367750 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Last week we extended the SAP BW support for SQL Server 2012 column-store by releasing SAP note 1951490. The correction instructions of this note contain several improvements….


Increasing BW cube compression performance

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Increasing-BW-cube-compression-performance/ba-p/367736 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Last year we already released an SAP note regarding BW cube compression performance, containing a correction instruction. The text of this note has been updated last week….