Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
New Features
New Features
| Feature/Capability | Express | Workgroup | Standard | Enterprise |
|---|---|---|---|---|
| Number of processors | 1 | 2 | 4 | Unlimited |
| Memory | 1GB | 3GB | OS limits | OS limits |
| 64-bit support | Emulated; Windows on Windows (WOW) | Emulated; Windows on Windows (WOW) | Yes | Yes |
| Database size limit | 4GB | None | None | None |
| Database Partitioning | No | No | No | Yes |
| Failover Clustering | No | No | 2 Nodes | Yes |
| Database Mirroring | No | No | Yes | Yes |
| Backup Log Shipping | No | Yes | Yes | Yes |
| Online Indexing | No | No | No | Yes |
| Management Studio | Express Version | Yes | Yes | Yes |
| Full-Text Search | No | Yes | Yes | Yes |
| SQL Server Agent | No | Yes | Yes | Yes |
| Notification Services | No | No | Yes | Yes |
| Service Broker | As a subscriber only | Yes | Yes | Yes |
| HTTP Endpoints | No | No | Yes | Yes |
| Report Server | Yes | Yes | Yes | Yes |
| Report Builder | No | Yes | Yes | Yes |
| BI Development Studio | Report Designer only | Report Designer only | Yes | Yes |
| Analysis Services | No | No | Yes | Yes |
| SQL Server Integration Services (SSIS) with basic transforms | No | No | Yes | Yes |
| SSIS with advanced transforms | No | No | No | Yes |
