Microsoft KB Archive/299905

= INF: Data Types Used by Analysis Services =

Article ID: 299905

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q299905



SUMMARY
The values associated with the Data Type and Key Data Type properties are Microsoft ActiveX Data Objects (ADO) data types.



MORE INFORMATION
The Data Types and Key Data Types properties used in an Analysis Services database affect the size of the records contained in the database. The size of a record affects Analysis Services performance in all areas, including cube size, processing time, server memory usage, server to client data transfer time, and client memory usage. The values for both the Data Type and Key Data Type properties are ADO data types. Information about the data types that are used for these properties are summarized in the following table: