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

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 may take several hours. The obvious way to speed-up this procedure would be to increase parallelism by setting the SQL Server configuration option “max degree of parallelism” (MaxDop)…. 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