Warning!! Scammers trick into transferring money to pay for services.
logo hostatom

No. 999/9 The Offices at Central World , 29th Floor, Rama 1 10330

Staff available 24x7.

Ready to give advice at all times

0-2107-3466

contact us

0-2107-3466 Contact us

Staff available 24x7.

Ready to give advice at all times

No. 999/9 The Offices at Central World , 29th Floor, Rama 1 10330

Compare Microsoft SQL Server

Each edition of Microsoft SQL Server supports different performance, runtime, and pricing requirements based on your application needs. Installation depends on your specific requirements, with SQL Server Express available as a free download. But there is a maximum database size of 10GB and other limitations. That’s more than the paid version.
FeatureExpressWebStandardEnterprise
Max. compute capacity used by a single instanceLesser of 1 socket / 4 coresLesser of 4 sockets / 16 coresLesser of 4 sockets / 24 coresOS Max.
Max. memory for buffer pool per instance1410MB64 GB128GBOS Max.
Max. memory for Columnstore segment cache per instance352MB16 GB32GBUnlimited
Max. memory-optimized data size per database352MB16 GB32GBUnlimited
Max. relational database size10GB524PB524PB524PB
Log shipping
Database mirroring
Backup compression
Database snapshot
Always On availability groups
Basic availability groups
Encrypted backup
Stretch database
Table and index partitioning
Buffer pool extension
Data compression
Resource governor
In-Memory Database: In-Memory OLTP
Data classification and auditing
Data classification and auditing
Dynamic data masking
Always Encrypted with Secure Enclaves
Transparent Database Encryption (TDE)
Contained databases
Merge replication
Peer to peer transactional replication
Snapshot replication
SQL Server change tracking
Transactional replication
Transactional replication to Azure
SQL Server Agent
Dedicated admin connection
PowerShell scripting support
Full-text and semantic search
Common Language Runtime (CLR) Integration
Import/export of industry-standard spatial data formats
Database mail
UTF-8 support
Java Language Runtime Integration
PolyBase compute node
Master instance for big data cluster
Accelerated database recovery
Intelligent Database: automatic tuning
Intelligent Database: batch mode for row store
Intelligent Database: row mode memory grant feedback
Intelligent Database: approximate count distinct
Intelligent Database: table variable deferred compilation
Intelligent Database: scalar UDF inlining
Parallel query processing on partitioned tables and indexes
Not all properties in the table are available in SQL Server. To see more properties, see Can be found at SQL Server 2019 Features.
Request a quote | Terms of service