Der Vollständigkeit halber ein Vergleich der verschiedenen Versionen des SQL Server 2012.
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Max Cap. Single Instance (SQL Server Database Engine) | OS maximum | Max of 4 Sockets or 16 cores | Max of 4 Sockets or 16 cores | Max of 4 Sockets or 16 cores | Max of 1 Socket or 4 cores | Max of 1 Socket or 4 cores | Max of 1 Socket or 4 cores |
Max Cap. Single Instance (Analysis Services, Reporting Services) | OS maximum | OS maximum | Max of 4 Sockets or 16 cores | Max of 4 Sockets or 16 cores | Max of 1 Socket or 4 cores | Max of 1 Socket or 4 cores | Max of 1 Socket or 4 cores |
Max Mem (SQL Server Database Engine) | OS maximum | 64 GB | 64 GB | 64 GB | 1 GB | 1 GB | 1 GB |
Max Mem (Analysis Services) | OS maximum | OS maximum | 64 GB | N/A | N/A | N/A | N/A |
Max Mem (Reporting Services) | OS maximum | OS maximum | 64 GB | 64 GB | 4 GB | N/A | N/A |
Maximum relational Database size | 524 PB | 524 PB | 524 PB | 524 PB | 10 GB | 10 GB | 10 GB |
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Server Core support1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Log Shipping | Yes | Yes | Yes | Yes | |||
Database mirroring | Yes | Yes (Safety Full Only) | Yes (Safety Full Only) | Witness only | Witness only | Witness only | Witness only |
Failover Clustering | Yes Nodes OS maximum | Yes (Node support: 2) | Yes (Node support: 2) | ||||
Backup compression | Yes | Yes | Yes | ||||
Database snapshot | Yes | ||||||
AlwaysOn Availability Groups | Yes | ||||||
SQL Server Multi-Subnet Clustering | Yes | ||||||
Connection Director | Yes | ||||||
Online page and file restore | Yes | ||||||
Online indexing | Yes | ||||||
Online schema change | Yes | ||||||
Fast recovery | Yes | ||||||
Mirrored backups | Yes | ||||||
Hot Add Memory and CPU2 | Yes | ||||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Multi-instance support | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
Table and index partitioning | Yes | ||||||
Data compression | Yes | ||||||
Resource Governor | Yes | ||||||
Partition Table Parallelism | Yes | ||||||
Multiple Filestream containers | Yes | ||||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Basic Auditing | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Fine Grained Auditing | Yes | ||||||
Transparent database encryption | Yes | ||||||
Extensible Key Management | Yes | ||||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
SQL Server change tracking | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Merge replication | Yes | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
Transactional replication | Yes | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
Snapshot replication | Yes | Yes | Yes | Yes (Subscriber only | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
Heterogeneous subscribers | Yes | Yes | Yes | ||||
Oracle publishing | Yes | ||||||
Peer to Peer transactional replication | Yes | ||||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
SQL Management Objects (SMO) | Yes | Yes | Yes1 | Yes | Yes | Yes | Yes |
SQL Configuration Manager | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SQL CMD (Command Prompt tool) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SQL Server Management Studio | Yes | Yes | Yes | Yes | Yes | Yes | |
Distributed Replay – Admin Tool | Yes | Yes | Yes | Yes | Yes | Yes | |
Distributed Replay – Client | Yes | Yes | Yes | Yes | |||
Distributed Replay – Controller | Yes (Ent up to 16 clients, Dev only 1 client) | Yes (1 client support only) | Yes (1 client support only) | Yes (1 client support only) | |||
SQL Profiler | Yes | Yes | Yes | No2 | No2 | No2 | No2 |
SQL Server Agent | Yes | Yes | Yes | Yes | |||
MSCOM Management Pack | Yes | Yes | Yes | Yes | |||
Database Tuning Advisor (DTA) | Yes | Yes | Yes3 | Yes3 | |||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
User Instances | Yes | Yes | Yes | ||||
Dedicated admin connection | Yes | Yes | Yes | Yes | Yes (under trace flag) | Yes (under trace flag) | Yes (under trace flag) |
PowerShell scripting support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SysPrep support1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Support for Data-tier application component operations – extract, deploy, upgrade, delete | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Policy automation (check on schedule and change) | Yes | Yes | Yes | Yes | |||
Performance data collector | Yes | Yes | Yes | Yes | |||
Able to enroll as a managed instance in a multi-instance management | Yes | Yes | Yes | Yes | |||
Standard performance reports | Yes | Yes | Yes | Yes | |||
Plan guides and plan freezing for plan guides | Yes | Yes | Yes | Yes | |||
Direct query of indexed views (using NOEXPAND hint) | Yes | Yes | Yes | Yes | |||
Automatic indexed view maintenance | Yes | Yes | Yes | Yes | |||
Distributed partitioned views | Yes | Dist. part. View No UP | Dist. part. View No UP | Dist. part. View No UP | Dist. part. View No UP | Dist. part. View No UP | Dist. part. View No UP |
Parallel indexed operations | Yes | ||||||
Automatic use of indexed view by query optimizer | Yes | ||||||
Parallel consistency check | Yes | ||||||
SQL Server utility control point | Yes | ||||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Microsoft Visual Studio Integration | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SQL Server Developer Studio | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Intellisense (Transact-SQL and MDX) 1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SQL Server Data Tools (SSDT) | Yes | Yes | Yes | Yes | Yes | ||
SQL query edit and design tools1 | Yes | Yes | Yes | ||||
Version control support1 | Yes | Yes | Yes | ||||
MDX edit, debug, and design tools1 | Yes | Yes | Yes | ||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Common Language Runtime (CLR) Integration | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Native XML support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
XML indexing | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
MERGE & UPSERT Capabilities | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
FILESTREAM support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
FileTable | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Date and Time datatypes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Internationalization support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Full-text and semantic search | Yes | Yes | Yes | Yes | Yes | ||
Specification of language in query | Yes | Yes | Yes | Yes | Yes | ||
Service Broker (messaging) | Yes | Yes | Yes | No (Client only) | No (Client only) | No (Client only) | No (Client only) |
Web services (HTTP/SOAP endpoints) | Yes | Yes | Yes | Yes | |||
T-SQL endpoints | Yes | Yes | Yes | Yes | |||
Feature | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
SQL Server Import and Export Wizard | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Built-in data source connectors | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SSIS designer and runtime | Yes | Yes | Yes | ||||
Basic Transforms | Yes | Yes | Yes | ||||
Basic data profiling tools | Yes | Yes | Yes | ||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
High performance Oracle destination | Yes | ||||||
High performance Teradata destination | Yes | ||||||
SAP BW source and destination | Yes | ||||||
Data mining model training destination adapter | Yes | ||||||
Dimension processing destination adapter | Yes | ||||||
Partition processing destination adapter | Yes | ||||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Persistent (high performance) lookups | Yes | ||||||
Data mining query transformation | Yes | ||||||
Fuzzy grouping and lookup transformations | Yes | ||||||
Term extractions and lookup transformations | Yes | ||||||
Feature | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Master Data Services database | Yes | Yes | |||||
Master Data Manager web application | Yes | Yes | |||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Create cubes without a database | Yes | Yes | Yes | ||||
Auto-generate staging and data warehouse schema | Yes | Yes | Yes | ||||
Change data capture | Yes | ||||||
Star join query optimizations | Yes | ||||||
Scalable read-only Analysis Services configuration | Yes | ||||||
Proactive caching | Yes | ||||||
Parallel query processing on partitioned tables and indices | Yes | ||||||
Columnstore Indexes | Yes | ||||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Scalable Shared Databases (Attach/Detach, Read only databases) | Yes | Yes | |||||
High Availability | Yes | Yes | Yes | ||||
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) | Yes | Yes | Yes | ||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Semi-additive Measures | Yes | Yes | |||||
Hierarchies | Yes | Yes | Yes | ||||
KPIs | Yes | Yes | Yes | ||||
Perspectives | Yes | Yes | |||||
Actions | Yes | Yes | Yes | ||||
Account intelligence | Yes | Yes | Yes | ||||
Time Intelligence | Yes | Yes | Yes | ||||
Custom rollups | Yes | Yes | Yes | ||||
Writeback cube | Yes | Yes | Yes | ||||
Writeback dimensions | Yes | Yes | |||||
Writeback cells | Yes | Yes | Yes | ||||
Drillthrough | Yes | Yes | Yes | ||||
Advanced hierarchy types (Parent-Child, Ragged Hiearchies) | Yes | Yes | Yes | ||||
Advanced dimensions (Reference dimensions, many-to-many dimensions | Yes | Yes | Yes | ||||
Linked measures and dimensions | Yes | Yes | |||||
Translations | Yes | Yes | |||||
Aggregations | Yes | Yes | Yes | ||||
Multiple Partitions | Yes | Yes | Yes, up to 3 | ||||
Proactive caching | Yes | Yes | |||||
Custom Assemblies (stored procs) | Yes | Yes | Yes | ||||
MDX queries and scripts | Yes | Yes | Yes | ||||
Role-based security model | Yes | Yes | Yes | ||||
Dimension and Cell-level Security | Yes | Yes | Yes | ||||
Scalable string storage | Yes | Yes | Yes | ||||
MOLAP, ROLAP, HOLAP storage modes | Yes | Yes | Yes | ||||
Binary and compressed XML transport | Yes | Yes | Yes | ||||
Push-mode processing | Yes | Yes | |||||
Direct Writeback | Yes | Yes | |||||
Measure Expressions | Yes | Yes | |||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Hierarchies | Yes | Yes | |||||
KPIs | Yes | Yes | |||||
Semi-additive Measures | Yes | Yes | |||||
Perspectives | Yes | Yes | |||||
Translations | Yes | Yes | |||||
DAX calculations, DAX queries, MDX queries | Yes | Yes | |||||
Row-level Security | Yes | Yes | |||||
Partitions | Yes | Yes | |||||
VertiPaq and DirectQuery storage modes (Tabular only) | Yes | Yes | |||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
SharePoint farm integration based on shared service architecture | Yes | Yes | |||||
Usage reporting | Yes | Yes | |||||
Health monitoring rules | Yes | Yes | |||||
PowerPivot Gallery | Yes | Yes | |||||
PowerPivot Data Refresh | Yes | Yes | |||||
PowerPivot Data Feeds | Yes | Yes | |||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Standard Algorithms | Yes | Yes | Yes | ||||
Data Mining Tools (Wizards, Editors Query Builders) | Yes | Yes | Yes | ||||
Cross Validation | Yes | Yes | |||||
Models on Filtered Subsets of Mining Structure Data | Yes | Yes | |||||
Time Series: Custom Blending Between ARTXP and ARIMA Methods | Yes | Yes | |||||
Time Series: Prediction with New Data | Yes | Yes | |||||
Unlimited Concurrent DM Queries | Yes | Yes | |||||
Advanced Configuration & Tuning Options for Data Mining Algorithms | Yes | Yes | |||||
Support for plug-in algorithms | Yes | Yes | |||||
Parallel Model Processing | Yes | Yes | |||||
Time Series: Cross-Series Prediction | Yes | Yes | |||||
Unlimited attributes for Association Rules | Yes | Yes | |||||
Sequence Prediction | Yes | Yes | |||||
Mult. Predict. Targets for Naïve Bayes, Neural Network and Log. Regr. | Yes | Yes | |||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Supported catalog DB SQL Server edition | Standard or higher | Standard or higher | Standard or higher | Web | Express | ||
Supported data source SQL Server edition | All SQL Server editions | All SQL Server editions | All SQL Server editions | Web | Express | ||
Report Server | Yes | Yes | Yes | Yes | Yes | ||
Report Designer | Yes | Yes | Yes | Yes | Yes | ||
Report Manager | Yes | Yes | Yes | Yes | Yes | ||
Role based security | Yes | Yes | Yes | Yes | Yes | ||
Word Export and Rich Text Support | Yes | Yes | Yes | Yes | Yes | ||
Enhanced gauges and charting | Yes | Yes | Yes | Yes | Yes | ||
Export to Excel, PDF, and Images | Yes | Yes | Yes | Yes | Yes | ||
Custom authentication | Yes | Yes | Yes | Yes | Yes | ||
Report as data feeds | Yes | Yes | Yes | Yes | Yes | ||
Model support | Yes | Yes | Yes | Yes | |||
Create custom roles for role-based security | Yes | Yes | Yes | ||||
Model Item security | Yes | Yes | Yes | ||||
Infinite click through | Yes | Yes | Yes | ||||
Shared component library | Yes | Yes | Yes | ||||
Email and file share subscriptions and scheduling | Yes | Yes | Yes | ||||
Report history, execution snapshots and caching | Yes | Yes | Yes | ||||
SharePoint Integration | Yes | Yes | Yes | ||||
Remote and non-SQL data source support1 | Yes | Yes | Yes | ||||
Data source, delivery and rendering, RDCE extensibility | Yes | Yes | Yes | ||||
Data driven report subscription | Yes | Yes | |||||
Scale out deployment (Web farms) | Yes | Yes | |||||
Alerting2 | Yes | Yes | |||||
Power View2 | Yes | Yes | |||||
For this edition of SQL Server Reporting Services | Use the DB Eng to host the database | ||||||
Enterprise | Std, BI Ent Edit. | ||||||
Business Intelligence | Std, BI Ent Edit. | ||||||
Standard | Std, Ent editions (local or remote) | ||||||
Web | Web edition (local only) | ||||||
Express with Advanced Services | Ex Advanced Services (local only). | ||||||
Evaluation | Evaluation | ||||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Report Builder | Yes | Yes | Yes | ||||
Data Mining Addins for Excel and Visio 2010 | Yes | Yes | Yes | ||||
PowerPivot for Excel 2010 | Yes | Yes | |||||
Master Data Services Add-in for Excel | Yes | Yes | |||||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Spatial indexes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Planar and Geodetic datatypes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Advanced spatial libraries | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Import/export of industry-standard spatial data formats | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
SQL Server Migration Assistant | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Database mail1 | Yes | Yes | Yes | Yes | |||
Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
Data Quality Services | Yes | Yes | |||||
StreamInsight | StreamInsight Premium Edition | StreamInsight Standard Edition | StreamInsight Standard Edition | StreamInsight Standard Edition | |||
StreamInsight HA | StreamInsight Premium Edition |
In SQL Server 2016 wurde das sog. dynamic data masking eingeführt. Eine Möglichkeit Daten bei…
Seit Sharepoint Server 2007 präsentiert sich die Installation immer auf die gleiche Weise. Gerade mal,…
Es weihnachtet! Gerade bekam ich von einer Kollegin Plätzchen angeboten mit der Größe eines Diskus…
Nein, bitte nicht verwechseln: temporal tables haben nichts zu tun mit temporary tables table variables…
SQL Server 2016.. habe ich schon erwähnt, dass ich den ziemlich cool finde? Wollen wir…
Nach langer Zeit wieder mal eine Artikel von mir.. der mich besonders erfreut. SQL Server…