Unlike the other editions of SQL Server, the SQL CE engine is based on SQL Mobile (initially designed for use with hand-held devices) and does not share the same binaries. Compact (SQL CE) The compact edition is an embedded database engine.
Specialized editions Azure Microsoft SQL Azure Database is the cloud-based version of Microsoft SQL Server, presented as software as a service on Azure Services Platform. SQL Server Express with Advanced Services adds full-text search capability and reporting services.
The first is SQL Server Express with Tools, which includes SQL Server Management Studio Basic. Two additional editions provide a superset of features not in the original Express Edition. It is intended as a replacement for MSDE. While there are no limitations on the number of databases or users supported, it is limited to using one processor, 1 GB memory and 4 GB database files (10 GB database files from SQL Server Express 2008 R2). Express SQL Server Express Edition is a scaled down, free edition of SQL Server, which includes the core database engine. Note that this edition has been retired in SQL Server 2012. Workgroup SQL Server Workgroup Edition includes the core database functionality but does not include the additional services. It includes the Standard Edition capabilities and Business Intelligence tools: PowerPivot, Power View, the BI Semantic Model, Master Data Services, Data Quality Services and xVelocity in-memory analytics. Business Intelligence Introduced in SQL Server 2012 and focusing on Self Service and Corporate Business Intelligence. Web SQL Server Web Edition is a low-TCO option for Web hosting. It differs from Enterprise edition in that it supports fewer active instances (number of nodes in a cluster) and does not include some high-availability functions such as hot-add memory (allowing memory to be added while the server is still running), and parallel indexes. Standard SQL Server Standard edition includes the core database engine, along with the stand-alone services. It can manage databases as large as 524 petabytes and address 2 terabytes of memory and supports 8 physical processors. Enterprise SQL Server Enterprise Edition includes both the core database engine and add-on services, with a range of tools for creating and managing a SQL Server cluster. Comes with StreamInsight Premium edition. The Datacenter edition has been retired in SQL Server 2012, all its features are available in SQL Server 2012 Enterprise Edition. It supports 256 logical processors and virtually unlimited memory. Mainstream editions Datacenter SQL Server 2008 R2 Datacenter is the full-featured edition of SQL Server and is designed for datacenters that need the high levels of application support and scalability.
0 kommentar(er)
