X hits on this document

Word document

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and ... - page 32 / 76

254 views

0 shares

0 downloads

0 comments

32 / 76

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability28

Figure 11

Data types used by SAP

SAP uses simple data types including:

Variable length character types only

Normal integers and a few small integers

Float and decimal, especially for the SAP BW fact tables

In addition, for SQL Server 2005 the varbinary(max) data type is used instead of the image data type for BLOB and Clob fields. The data type image/varbinary(max) is used in approximately 450 tables. The data type is changed from image to varbinary(max) as a metadata operation only. No data movement takes place when changing the data type. For more information, see SAP OSS Note 799058.

Note that SAP does not use user-defined data types and SQL variants.

Microsoft Corporation © 2005

Document info
Document views254
Page views254
Page last viewedMon Dec 05 16:53:28 UTC 2016
Pages76
Paragraphs1372
Words23715

Comments