2012. május 19., szombat
licenseport
regisztráció
Link küldés
.
Cikk nyomtatás
Link küldés
.
Cikk nyomtatás
Link küldés
.
Cikk nyomtatás
menü
Termékinformációk >> Microsoft >> Szerver rendszerek
menü
menü
menü
SQL Server 2008 - a kiadások összehasonlítása
Detailed Feature Comparison
 Core Editions
 Specialized Editions
Enterprise
 Standard
 Workgroup
 Web
 Express
Scalability & Performance
  
  
  
  
  
Number of CPUs
 OS Maximum
 4
 2 CPU
 4 CPU
 1 CPU
(WEB WORKLOADS ONLY)
Memory Utilization
 OS Maximim
 OS Maximum
 4 GB Ram
 OS Maximim
 1 GB Ram
Database Size
 Unlimited
 Unlimited
 Unlimited
 Unlimited
 4GB
Multi-Instance Support
 50 instances
 16
 16
 16
 16
x32 Hardware Support
 o
 o
 o
 o
 o
x64 Hardware Support
 o
 o
 o
 o
 o
Dynamic Address Windows Extensions Memory Management
 o
 o
  
  
  
Data Compression
 o
  
  
  
  
Resource Governor
 o
  
  
  
  
I64 Hardware Support
 o
  
  
  
  
Hypervisor Support
 o
 o
 o
 o
 o
Table and Index Partitioning
 o
  
  
  
  
Parallel Index Operations
 o
  
  
  
  
Parallel Consistency Checks (DBCC)
 o
  
  
  
  
Scalable Shared Databases
 o
  
  
  
  
Indexed Views
 o
  
  
  
  
Enhanced Read-ahead and Scan
 o
  
  
  
  
High Availability (Always On)
  
  
  
  
  
Multi-instance Support
 50 instances
 16
 16
 16
 16
Database Mirroring
 Full
 Single-thread
 Witness only
 Witness only
 Witness only
Clustering
 16-node failover clustering
 2-node failover clustering
  
  
  
Online System Changes
 o
 o
 o
 o
 o
Backup Log Shipping
 o
 o
 o
 o
 o
Automatic Corruption Recovery from Mirror
 o
 o
  
  
  
Log Stream Compression
 o
 o
  
  
  
Online Indexing
 o
  
  
  
  
Mirrored Backups
 o
  
  
  
  
Resource Governor
 o
  
  
  
  
Backup Compression
 o
  
  
  
  
Hot-add Memory and CPU Support
 o
  
  
  
  
Database Snapshots
 o
  
  
  
  
Fast Recovery
 o
  
  
  
  
Online Page and File Restore
 o
  
  
  
  
Parallel Index Operations
 o
  
  
  
  
Updated Distributed Partioned Views
 o
  
  
  
  
Table and Index Partitioning
 o
  
  
  
  
Replication
  
  
  
  
  
SQL Server Change Tracking
 o
 o
 o
 o
 o
Merge Replication
 o
 o
 Subscriber only
 Subscriber only
 Subscriber only
Transactional Replication
 o
 o
 Subscriber only
 Subscriber only
 Subscriber only
Snapshot Replication
 o
 o
 Subscriber only
 Subscriber only
 Subscriber only
Heterogeneous Subscribers
 o
 o
  
  
  
Oracle Publishing
 o
  
  
  
  
Enterprise Security
  
  
  
  
  
C2 Complaint Tracing
 o
 o
 o
 o
 o
SQL Auditing Foundation
 o
 o
 o
 o
 o
Fine Grained Auditing
 o
  
  
  
  
Transparent Database Encryption
 o
  
  
  
  
Extensible Key Management
 o
  
  
  
  
Enterprise Manageability
  
  
  
  
  
Policy Based Configuration
 o
 o
 o
 o
 o
Database Migration Tools
 o
 o
 o
 o
 o
Policy-Based Management
 o
 o
 o
 o
 o
Streamlined Installation
 o
 o
 o
 o
 o
SQL Server Management Studio Tools
 o
 o
 o
 o
 o
Database Mail
 o
 o
 o
 o
  
Performance Data Collection
 o
 o
 o
 o
  
SQL Profiler
 o
 o
 o
 o
  
SQL Server Agent
 o
 o
 o
 o
  
Database Tuning Advisor
 o
 o
 o
 o
  
Plan Freezing
 o
 o
  
  
  
Standard Performance Reports
 o
 o
  
  
  
Distributed Partition Views
 o
  
  
  
  
Parallel Index Operations
 o
  
  
  
  
Automatic Query- to- index- View Matching
 o
  
  
  
  
Parallel Database Backup Checksum Check
 o
  
  
  
  
Unlimited Virtualization
 o
  
  
  
  
Data Warehousing
  
  
  
  
  
Create Cubes Without a Database
 o
 o
  
  
  
Auto-generate Staging and Datawarehouse Schema
 o
 o
  
  
  
Attribute Relationship Designer
 o
 o
  
  
  
Efficient Aggregation Designers
 o
 o
  
  
  
Scalable read-only AS
 o
  
  
  
  
Partitioned Cubes
 o
  
  
  
  
Distributed Partitioned Cubes
 o
  
  
  
  
Data Compression
 o
  
  
  
  
Star Join Query Optimizations
 o
  
  
  
  
Change Data Capture (CDC)
 o
  
  
  
  
Integration Services
  
  
  
  
  
SQL Server Import and Export Wizard
 o
 o
 o
 o
 o
Log Providers and Logging
 o
 o
  
  
  
XML Source
 o
 o
  
  
  
SSIS Run-time
 o
 o
  
  
  
Basic Data Profiling Tools
 o
 o
  
  
  
SSIS Package Designer & Service
 o
 o
  
  
  
Data Mining Query Transformation
 o
  
  
  
  
Data Mining Model Training Destination Adapter
 o
  
  
  
  
Fuzzy Grouping Transformation
 o
  
  
  
  
Fuzzy Lookup Transformation
 o
  
  
  
  
Term Extraction Transformation
 o
  
  
  
  
Dimension Processing Destination Adapter
 o
  
  
  
  
Partition Processing Destination Adapter
 o
  
  
  
  
Reporting Services
  
  
  
  
  
Reporting Services Memory Limits
 Unlimited
 Unlimited
 4GB
 4GB
 4GB
Report Designer
 o
 o
 o
 o
 o
Report Manager
 o
 o
 o
 o
 o
(report manager)
 (report manager)
Role-based Security
 o
 o
 o
 o
 o
(fixed roles)
 (fixed roles)
 (fixed roles)
Enhanced Gauges and Charting
 o
 o
 o
 o
  
Basic Data Profiling Tools
 o
 o
 o
 o
 o
Export to Excel, Word, PDF and Images
 o
 o
 o
 o
 o
Microsoft Office Integration
 o
 o
 o
 o
 o
Custom Authentication
 o
 o
 o
 o
  
Report Server Application Embedding
 o
 o
 o
 o
 o
Ad-hoc Reporting (Report Builder)
 o
 o
 o
  
  
Scale-out Operational Report Configuration
 o
  
  
  
  
SharePoint Integration
 o
 o
  
  
  
Email and File Share Delivery
 o
 o
  
  
  
Report History, Scheduling, Subscriptions and Caching
 o
 o
  
  
  
Data Source, Delivery and Rendering Extensibility
 o
 o
  
  
  
Data-driven Report Subscriptions
 o
  
  
  
  
Report Scale-out Deployment
 o
  
  
  
  
Infinite Click-through in Ad-hoc Reports
 o
  
  
  
  
Analysis Services
  
  
  
  
  
Analysis Services Backup
 o
 o
  
  
  
Dimension, Attribute Relationship, Aggregate & Cube Design
 o
 o
  
  
  
Personalization Extensions
 o
 o
  
  
  
Analysis Services Scalable Shared Databases
 o
  
  
  
  
Account Intelligence
 o
  
  
  
  
Linked Measures and Dimensions
 o
  
  
  
  
Perspectives
 o
  
  
  
  
Semi-additive Measures
 o
  
  
  
  
Writeback Dimensions
 o
  
  
  
  
Partitioned Cubes and Distributed Partitioned Cubes
 o
  
  
  
  
Custom Rollups
 o
  
  
  
  
Data Mining
  
  
  
  
  
Excel 2007 and Visio 2007 Add-in Support
 o
 o
  
  
  
Comprehensive Set of DM Algorithms
 o
 o
  
  
  
Integrated Data Mining Tools (Wizards, Editors, Model Viewers, Query Builder)
 o
 o
  
  
  
Parallel Model Processing
 o
  
  
  
  
Cross Validation
 o
  
  
  
  
Support for Plug-in Algorithms
 o
  
  
  
  
Advanced Configuration and Tuning Options for Data Mining Algorithms
 o
  
  
  
  
Support for Pipeline Data Mining and Text Mining with Integration Services
 o
  
  
  
  
Sequence Prediction
 o
  
  
  
  
Programmability
  
  
  
  
  
MERGE and Upsert Capabilities
 o
 o
 o
 o
 o
New Date and Time Data Types
 o
 o
 o
 o
 o
Internationalization Support
 o
 o
 o
 o
 o
Full Text Search
 o
 o
 o
 o
 o
Common Language Runtime (CLR) Integration
 o
 o
 o
 o
 o
Native XML Support
 o
 o
 o
 o
 o
XML Indexing
 o
 o
 o
 o
 o
FILESTREAM Support
 o
 o
 o
 o
 o
Entity Framework Support
 o
 o
 o
 o
 o
Spatial Support
 o
 o
 o
 o
 o
Development Tools
  
  
  
  
  
Microsoft Visual Studio Integration
 o
 o
 o
 o
 o
Intellisense (Transact-SQL-and MDX)
 o
 o
 o
 o
 o
MDX Edit, Debug and Design Tools
 o
 o
  
  
  
Spatial and Location Services
  
  
  
  
  
Spatial Indexes
 o
 o
 o
 o
 o
Geodetic Data Type
 o
 o
 o
 o
 o
Advanced Spatial Libraries
 o
 o
 o
 o
 o
Standards-based Spatial Support
 o
 o
 o
 o
 o
Link küldés
.
Cikk nyomtatás
belépés
belépés
keresés
keresés
rss
Legfrissebb híreink és akcióink
hírek