![]() Setting the database compatibility to a higher level is irreversible. ![]() You can also specify it for databases created in earlier versions of to enable the use of features that are supported only at this compatibility level (namely, increased string storage for dimension attributes or distinct count measures that contain string data).ĭatabases that have a CompatibilityLevel set to 1100 get an additional property, StringStoresCompatibilityLevel, that lets you choose alternative string storage for partitions and dimensions. This is the default value for new databases that you create in or. Any database that does not have CompatibilityLevel explicitly set is implicitly running at the 1050 level. This value is not visible in script or tools, but it corresponds to databases created in, , or. By raising the database compatibility level, you can override the 4 gigabyte maximum limit for string storage of measures and dimensions.įor a multidimensional database, valid values for the CompatibilityLevel property include the following: Setting See What is new for the Tabular model in SQL Server 2012 SP1 and compatibility level for more information about 1103 for tabular solutions.Ĭompatibility Levels for multidimensional databasesĬurrently, the only multidimensional database behavior that varies by functional level is string storage architecture. Compatibility level 1103 does not exist for multidimensional models. Tabular models have additional database compatibility levels that are not applicable to multidimensional models. For more information about tabular solutions, see Compatibility Level for Tabular models in Analysis Services. This topic describes compatibility level for multidimensional databases only. For example, a compatibility level of 1100 has a different meaning depending on whether the database is multidimensional or tabular. ![]() Compatibility levels are unique to each model type. In, the database compatibility level property determines the functional level of a database. Compatibility Level of a Multidimensional Database (Analysis Services)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |