Warning! Scammers trick people into transferring money.View

Warning! ScammersView

  • No. 999/9 The Offices at Central World
    Building, 29th Floor, Rama 1 10330
  • Staff available 24x7
    Ready to give advice at all times
  • 0-2107-3466
    Contact us
Facebook Twitter Youtube

Compare each version of 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 shippingnoyesyesyes
Database mirroringyesyesyesyes
Backup compressionnonoyesyes
Database snapshotyesyesyesyes
Always On availability groupsnononoyes
Basic availability groupsnonoyesno
Encrypted backupnonoyesyes
Stretch databaseyesyesyesyes
Table and index partitioningyesyesyesyes
Buffer pool extensionnonoyesyes
Data compressionyesyesyesyes
Resource governornonoyesyes
In-Memory Database: In-Memory OLTPyesyesyesyes
Data classification and auditingyesyesyesyes
Dynamic data maskingyesyesyesyes
Always Encrypted with Secure Enclavesyesyesyesyes
Transparent Database Encryption (TDE)noyesyesyes
Contained databasesyesyesyesyes
Merge replicationyesyesyesyes
Peer to peer transactional replicationnononoyes
Snapshot replicationyesyesyesyes
SQL Server change trackingyesyesyesyes
Transactional replicationyesyesyesyes
Transactional replication to Azurenonoyesyes
SQL Server Agentnoyesyesyes
Dedicated admin connectionyesyesyesyes
PowerShell scripting supportyesyesyesyes
Full-text and semantic searchnoyesyesyes
Common Language Runtime (CLR) Integrationyesyesyesyes
Import/export of industry-standard spatial data formatsyesyesyesyes
Database mailnoyesyesyes
UTF-8 supportyesyesyesyes
Java Language Runtime Integrationyesyesyesyes
PolyBase compute nodeyesyesyesyes
Master instance for big data clusternonoyesyes
Accelerated database recoverynoyesyesyes
Intelligent Database: automatic tuningnononoyes
Intelligent Database: batch mode for row storenononoyes
Intelligent Database: row mode memory grant feedbacknononoyes
Intelligent Database: approximate count distinctyesyesyesyes
Intelligent Database: table variable deferred compilationyesyesyesyes
Intelligent Database: scalar UDF inliningyesyesyesyes
Parallel query processing on partitioned tables and indexesnononoyes
The properties in a table are not all SQL Server properties. If you want to see other features can be viewed at SQL Server 2022 Features
Request a quote | Terms of service