100%(15)15 out of 15 people found this document helpful
This preview shows page 1 - 2 out of 4 pages.
DBMS Specification TableGroup CIT-204 Intro to Data and Info MgmtApril 9, 2017DBMS Assigned: Microsoft SQL ServerSpecification Category Specification/CommentsSpecification/Comments1. Data Size LimitsEnforces table, data type, and column length levelIdentifiers maximum: 128 characters.Column maximum: o1,024 non-wide o30,000 wide columns. Data type maximum: 32,767. Enables variable length columns, maximum 8,000 bytes per row.2. Purchase CostMultiple package options available oEnterprise Requires a dedicated IT department oStandardRecommended for “non-critical workloads”does not require IT departmentoExpress which is ideal for smaller groups and learning the system. Price range: $0 to $14,500 plus additional costs. The Standard package pricing options:oServer plus CAL (Client Access License). Cost: $931, for the server; additional fee for every user or device accessing the systemBest for exact numbers of users.