SQL Server Version Compare

Leave a comment (0) Go to comments

SQL Server Version Compare LIST

During one of my training session a college graduate asked me a question, Could you please provide me a quick comparison between the SQL Server versions.

I answered him that there is no such table as there are some feature which are available to specific editions only. But he insisted to have a small table to compare SQL Server Versions.

So I promised him to build a quick list to provide, here you go Pawan (who asked this question)

SQL Server Version Comparison

Features SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012
IA64 hardware support Available Available Available Available Available
Maximum database size
(as per BOL)
1,048,516 TB 524,258 terabytes 524,272 terabytes 524,272 terabytes 524,272 terabytes
Maximum memory utilized
(Enterprise Edition both SQL as well as Windows)
64 GB
(Datacenter)
OS maximum OS maximum OS maximum OS maximum
Number of CPUs Enterprise Edition 32
(Datacenter)
Operating system maximum Operating system maximum Operating system maximum Operating system maximum
Resource governor NA NA Available Available Available
Distributed Partition Views NA NA Available Available Available
Parallel consistency checks (DBCC) NA NA Available Available Available
Log shipping Available Available Available Available Available
Database mirroring NA Available
(SP1) onwards
Available Available Available
Automatic corruption recovery from mirror NA NA Available Available Available
Mirrored backups NA NA Available Available Available
Online indexing NA Available Available Available Available
Hot add memory and CPU support NA NA Available Available Available
Online page and file restore NA NA Available Available Available
Virtualization Support NA NA Available Available Available
Peer to Peer replication NA Available Available Available Available
Transparent database encryption NA NA Available Available Available
Policy-Based Management NA NA Available Available Available
Database mail NA NA Available Available Available
Plan guides GUI NA NA
sp_control plan_guide was available
Available Available Available
DAC NA Available Available Available Available
SQL Server Configuration Manager NA NA Available Available Available
SQL Server Surface Area Configuration NA Available NA NA NA
IntelliSense NA NA Available Available Available
FILESTREAM support NA NA Available Available Available
Spatial Data type Support NA NA Available Available Available
Stream Insight NA NA NA Available Available
Change data capture NA NA Available Available Available
Data compression NA NA Available Available Available
Star join NA NA Available Available Available
Master Data Service NA NA NA Available Available
HADR – High Availability & Disaster recovery  (Always ON) NA NA NA NA Available
PIVOT and UNPIVOT NA Available Available Available Available
Common Language Runtime NA Available Available Available Available
Service Broker NA Available Available Available Available
Data encryption NA Available Available Available Available
HTTP endpoints NA Available Available Available Available
Multiple Active Result Sets NA Available Available Available Available
SSIS Support NA Available Available Available Available
Data Center Edition NA NA NA Available NA
Parallel Data Warehouse NA NA NA Available NA
Power Pivot NA NA NA Available Available
Data-Tier Application NA NA NA Available Available
Multi Server Dashboards NA NA NA Available Available
Data Collector NA NA Available Available Available
Filtered Indexes NA NA Available Available Available
Plan freezing NA NA Available Available Available

Activity Monitor


NA NA Available Available Available
Central Management Servers NA NA Available Available Available
Data Collector and Management Data Warehouse NA NA Available Available Available
Ad Hoc Query Paging NA NA NA NA Available
Column Based Query Accelerator NA NA NA NA Available
FileTable NA NA NA NA Available
Business Intelligence Edition NA NA NA NA Available
Contained Databases NA NA NA NA Available
DMV’s NA Available Available Available Available
XML data type NA Available Available Available Available
SQL Server Management Objects (SMO) NA Available Available Available Available
           
Common Table Expresssions (CTEs) NA Available Available Available Available
.NET triggers NA Available Available Available Available
Database snapshots NA Available Available Available Available
DDL triggers NA Available Available Available Available
Row versioning-based isolation level NA Available Available Available Available
Data Quality Service NA NA NA NA Available
Sequences NA NA NA NA Available

NOTE -  This is not a complete list and in most of time I assumed Enterprise edition only for this Microsoft SQL Server Version Comparison

EOF - SQL Server Version Compare, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.