DBMS Specification Table - DBMS Specification Table Group C IT-204 Intro to Data and Info Mgmt April 9 2017 DBMS Assigned Microsoft SQL Server

DBMS Specification Table - DBMS Specification Table Group C...

This preview shows page 1 - 2 out of 4 pages.

DBMS Specification Table Group C IT-204 Intro to Data and Info Mgmt April 9, 2017 DBMS Assigned: Microsoft SQL Server Specification Category Specification/Comments Specification/Comments 1. Data Size Limits Enforces table, data type, and column length level Identifiers maximum: 128 characters. Column maximum: o 1,024 non-wide o 30,000 wide columns. Data type maximum: 32,767. Enables variable length columns, maximum 8,000 bytes per row. 2. Purchase Cost Multiple package options available o Enterprise Requires a dedicated IT department o Standard Recommended for “non-critical workloads” does not require IT department o Express which is ideal for smaller groups and learning the system. Price range: $0 to $14,500 plus additional costs. The Standard package pricing options: o Server plus CAL (Client Access License). Cost: $931, for the server; additional fee for every user or device accessing the system Best for exact numbers of users.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture