ABAP Select For All Entries – what is happening in SQL Server?

One of the query types one gets confronted with when running SAP Netweaver based applications is a special form of Open SQL statement in ABAP which is called ‘For all Entries’ (FAE). Standard ANSI SQL does not contain the command SELECT FOR ALL ENTRIES and therefore this command can be translated a number of different… Read more

Oracle to SQL SAP OS/DB Migration FAQ: Update January 2012 : v4.0

OS/DB Migration from UNIX/Oracle or DB2 to Commodity Intel servers running Windows & SQL Server  Attached to this blog is a PDF file with many useful hints and procedures for customers moving SAP systems to Win/SQL Increased Number of Migrations to Windows SQL Server The PDF file attached to this blog is an accumulation of… Read more

Faster DBCC CHECKDB Released in SQL 2008 R2 SP1 CU4 : Traceflag 2562 & 2549

  CHECKDB Times are Reduced with New CHECKDB Functionality Customers with larger databases are recommended to upgrade to SQL 2008 R2 SP1 Cumulative Update 4 to benefit from new improved CHECKDB functionality described in KB2634571.    CHECKDB Runtimes are Currently Too Long SAP on Windows SQL customers now have databases 16-17TB.  Customers larger than 10TB are… Read more

Performance of index creation

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-of-index-creation/ba-p/367170 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 The creation of database indexes is often a significant part in SAP BW process chains. Even on up-to-date database servers the index creation on a BW cube… Read more

Microsoft JDBC driver 1.2: sqljdbc driver fails to establish secure connection

If you are using the Microsoft JDBC driver 1.2 for your NetWeaver AS Java, you can get the following error message when your application server tries to connect to SQL Server: SEVERE: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: The TDS protocol… Read more

Microsoft’s SAP Deployment and SQL Server 2012

Microsoft’s internal ERP solution is the SAP Suite of products including SAP ECC 6.0, SAP BW and SAP SCM. Microsoft tests new SQL Server releases and Service Packs on not only test SAP systems but also the core ECC Production system that runs Microsoft worldwide. The ECC 6.0 single instance, single client system is accessed… Read more

SAP 7.20 Downwards Compatible Kernel is Finally Released

The SAP Downwards Compatible Kernel has finally been released after a long testing program. The 7.20 DCK kernel allows customers to greatly simplify their SAP landscape and also allows customers to use some enhanced features. The procedure for installing the 7.20 is documented in SAP OSS Note: 1636252 – Installing a 7.20 kernel in SAP… Read more

Upgrade Path to SQL 2008 (R2) and Windows Server 2008 R2

If you want to upgrade your SAP landscape to SQL 2008 (R2) and Windows Server 2008 R2 there are two possibilities. In this blog I will explain the differences between the two approaches and the advantages and disadvantages of both. Since old SAP releases are not supported on Windows Server 2008 R2 and SQL Server… Read more

How to virtualize SAP GUI using Microsoft App-V

  Update 5 Tuesday 06/25/2013       I added a new section at the end of the troubleshooting section in theattached paper. It talks about calling SAP GUI for Windows out of IE.There are two common methods to accomplish this :a, SSF – via SAP shortcut file : extension .sapb, SSD – via Structured Storage Document… Read more

Uneven Windows Processor Groups

The theme discussed in this blog does apply only to hardware which has more than 64 Logical Processors. All hardware with less Logical Processor threads exposed to the Operating System is not affected by the subjects described in this article. In these blog articles: http://blogs.msdn.com/b/saponsqlserver/archive/2010/09/28/windows-2008-r2-groups-processors-sockets-cores-threads-numa-nodes-what-is-all-this.aspx http://blogs.msdn.com/b/saponsqlserver/archive/2011/04/18/how-many-logical-processors-does-sql-server-2008-r2-enterprise-edition-support.aspx http://blogs.msdn.com/b/saponsqlserver/archive/2011/04/20/changes-in-affinity-settings-of-sql-server-2008-r2-to-support-gt-64-logical-processors.aspx we talked about Windows Server 2008 R2 and… Read more