Embed
|
Over view | Review |
Microsoft SQL ServerDatabase Management System by Microsoft |
|
Type System | Static |
Software License | Proprietary |
Interface | Compare by Interface GUI Multiple SQL |
Access Control | Audit Enterprise Directory Compatibility Native Network Encryption Password Complexity Rules Patch Access Resource Limit Run Unprivileged Security Certification Separation of Duties |
Indexes | Expression Full-text Partial Spatial |
Partitioning | Range |
Other Objects | Cursor Data Domain External Routine Function Procedure Trigger |
Tables and Views | Materialized Views Temporary Table |
Deployment Model | On Premise |
Database Capabilities | Blobs and Clobs Common Table Expressions Except Inner Joins Inner Selects Intersect Merge Joins Outer Joins Parallel Query Union Windowing Functions |
Features | Compare by Features ACID Referential Integrity Transactions Unicode |
Support Features | Blog Forums |
Integer | BIGINT SMALLINT TINYINT |
Floating Point | FLOAT REAL |
Decimal | DECIMAL MONEY NUMERIC SMALLMONEY |
String | CHAR NCHAR NTEXT NVARCHAR TEXT VARCHAR |
Boolean | BIT |
Binary | BINARY FILESTREAM IMAGE VARBINARY |
Date Time | DATE DATETIME DATETIME2 DATETIMEOFFSET SMALLDATETIME TIME |
Other | CURSOR HIERARCHYID SQL_VARIANT TABLE TIMESTAMP UNIQUEIDENTIFIER XML |
Max Blob Clob Size | 2 GB |
Max DB Size | 524,258 TB |
Max Table Size | 524,258 TB |
Max Column Name Size | 128 |
Max Row Size | Unlimited |
Max Columns per Row | 30000 |
Max DATE Value | 9999 |
Max CHAR Size | 2 GB |
Max NUMBER Size | 126 bits |
Min DATE Value | 1 |
Purchase Page | Purchase Page (microsoft.com) |
Organization | Microsoft Corporation |
Location | Redmond, WA |
Total Number of Employees | 10,000+ |
Sales Volume Range | 50B+ |
Address | Microsoft Corporation One Microsoft Way Redmond, Washington 98052-6399United States |
Website | Microsoft SQL Server (microsoft.com) |
Contact Link | Contact Link (support.microsoft.com) |
Phone | 1-800-642-7676 |
Fax | (425) 936-7329 |
Sponsored links |