Important SAP Notes on SQL Server

1076022: Release planning for Microsoft SQL Server 2008 (R2)
1152240: Setting Up Microsoft SQL Server 2008 (R2)
1144459: SQL4SAP and SAP Installation Media for SQL Server 2008

1473016: Service Pack Installation for SQL Server 2008
1279358: Cumulative Update Installation for SQL Server 2008
1260968: COPYTOSHADOW: R3trans loses reports

1237682: Configuration Parameters for SQL Server 2008

1600699: Microsoft jdbc driver 1.2 support

62988: Service Packs for Microsoft SQL Server
398136: Support Policy for Microsoft SQL Server
1177356: MS SQL Server: End of Support for SAP Releases
1027512: MSSQL: DBA cockpit for basis release 7.00 and later
683447: SAP Tools for MS SQL Server
1248222: ODBC DBSL profile parameters and connect options
208632: TCP/IP network protocol for MSSQL
128126: Database Connect for external tools
142731: DBCC checks of SQL Server
767691: Migration of SAP Systems to/from MS SQL Server
151603: Copying an SQL Server database
1086375: There is already an object named ‘..’ in the database
592514: MSSQL: internal database users, permissions and security
1294762: SCHEMA4SAP.VBS
1488135: Database compression for SQL Server
1459005: Enabling index compression for SQL Server
1238993: Proportional File Auto-Growth with SQL Server 2008
363018: File management for SQL Server

Database File Administration

32129: Deadlock analysis for the SQL server

Deadlocks

869407: Partitioning on MS SQL Server

1471910: SQL Server Partitioning in System Copies and DB Migrations

Table Partitioning (only relevant for SAP BW based systems)

965908: SQL Server Database Mirroring and SAP Applications
493290: Configuring SQL server Log shipping

High Availability

44449: Backup strategies with the SQL server
1297986: Backup and Restore strategy for MS SQL Server
1420452: FAQ: Restore and recovery with MS SQL Server
1048382: SQL Server: Third Party Backup Tool support

Backup and Recovery

1241751: SQL Server minimal logging extensions
1134345: Using locked pages for SQL Server
929031: Using SQL Server Profiler for JAVA (and ABAP)
159171: Recompilation of Stored Procedures
General Performance

129385: Database hints in Open SQL
133381: Database-Hints in Open SQL for MS SQL Server
1552952: Parameter maxmarkercnt increased to 10000

Performance -> Optimizer Hints

1380493: SQL Server Transparent Data Encryption (TDE)

Security