Create entry

Microsoft SQL Server

Microsoft SQL Server + Add column
Category
Preference (20% global votes)
Website www.​microsoft.​com/​sqlserver
License
Design
Database model
Data storage
Embeddable Yes
Features
Query language
Data types
Conditional entry updates Yes
Map and reduce No
Unicode Yes
TTL for entries No
Compression Yes
Integrity
Integrity model
Atomicity Yes
Consistency Yes
Isolation Yes
Durability (data storage) Yes
Transactions Conditional
Referential integrity Yes
Locking model
Indexing
Secondary Indexes Yes
Composite keys Yes
Full text search Yes
Geospatial Indexes Yes
Distribution
Horizontal scalable Yes
Replication Yes
Shared nothing architecture Yes
Restrictions
Value size max. 2.15 GB
System requirements
Operating system
Native driver
Architecture
Programming language
More
Description Relational Database Management System
Multi-user system Yes
Standard compliance Yes
Object-Relational Mapping (ORM) Yes
Documentation level ★★★☆☆
Free to use Conditional
Database Connection Pooling Yes
Real time analytics Yes
Community Driven No
Web interface No
Data encryption Yes
Cloud platform support
Online backup Yes
Key length max 68
Implementation flexibility (0% global votes)
Backup functionality Good
Query Cache Yes
Free for commercial use No
Sorts Yes
Open Source No
Triggers Yes
Perfomance ★★★★☆
Materialized Views Yes
Server Side Java Script No
JSON No
Stored Procedure Yes
Free edition Yes
User and Group role based security model Yes
Does your mom understand it No
+ Add row +
Microsoft SQL Server
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    darker
    = better
    Legend
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.

Type
Review
Comment