Using Columnstore on ERP tables
First published on MSDN on Apr 13, 2017 by Martin Merdes. 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 and in https://launchpad.support.sap.com/#/notes/2116639
Deletion of request in SAP BW orders of magnitude faster after installing SQL Server 2008 SP1 CU6
First published on MSDN on Feb 13, 2010. This blog post might be outdated by now. The latest documentation regarding BW Request Deletion on SQL Server is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html and in SAP Note 2116639Choosing SQL Server compression type for SAP
First published on MSDN on Serp 21, 2010 by Martin Merdes. This blog post might be outdated by now. The latest documentation regarding SQL Server Data Compression on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html and in https://launchpad.support.sap.com/#/notes/2116639Compressing an SAP database using report MSSCOMPRESS
First published on MSDN on Oct 08, 2010 by Martin Merdes. This blog post might be outdated by now. The latest documentation regarding report MSSCOMPRESS is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html and in https://launchpad.support.sap.com/#/notes/2116639Increased partition support of SQL Server in SAP BW
First published on MSDN on Mar 18, 2011 by Martin Merdes. This blog post might be outdated by now. The latest documentation regarding SQL Server Partitioning on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html and in https://launchpad.support.sap.com/#/notes/2116639Performance of index creation
First published on MSDN on Dec 11, 2011 by Martin Merdes. 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 and in https://launchpad.support.sap.com/#/notes/2116639 The performance impact of SQL Server Columnstore is described in https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-evolution-of-SAP-BW-on-SQL-Server/ba-p/368073SQL Server 2012 Column-store support for SAP BW
First published on MSDN on May 23, 2012 by Martin Merdes. 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 and in https://launchpad.support.sap.com/#/notes/2116639 The performance impact of SQL Server Columnstore is described in https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-evolution-of-SAP-BW-on-SQL-Server/ba-p/368073SAP BW improvements in new Support Package
First published on MSDN on Aug 17, 2012 by Martin Merdes. 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 and in https://launchpad.support.sap.com/#/notes/2116639 The performance impact of SQL Server Columnstore is described in https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-evolution-of-SAP-BW-on-SQL-Server/ba-p/368073
