Comparison of SQL Server versions

Today we will just review about the difference between most commonly used versions of SQL Server's.


     

SNo.	SQL Server 2000	SQL Server 2005	SQL Server 2008
1.	Query Analyser and Enterprise manager are separate.	Both are combined as SSMS (SQL Server management Studio).	Both are combined as SSMS (SQL Server management Studio).
2.	No XML datatype is used.	XML datatype is introduced.	XML datatype is used.
3.	We can create maximum of 65,535 databases.	We can create 32767 databases.	We can create 32767 databases.
4.	Nil	Exception Handling	Exception Handling
5.	Nil	Varchar(Max) data type	Varchar(Max) data type
6.	Nil	DDL Triggers.	DDL Triggers.
7.	Nil	DataBase Mirroring.	DataBase Mirroring.
8.	Nil	RowNumber function for paging.	RowNumber function for paging.
9.	Nil	Table fragmentation.	Table fragmentation.
10.	Nil	Full Text Search.	Full Text Search.
11.	Nil	Bulk Copy Update.	Bulk Copy Update.
12.	Nil	Cant encrypt	Can encrypt the entire database introduced in 2008
13.	Can’t compress the tables and indexes.	Can Compress tables and indexes (Introduced in 2005 SP2).	Can compress tables and indexes.
14.	Datetime datatype is used for both date and time.	Datetime datatype is used for both date and time.	Date and time are seperately used for date and time datatype,geospatial and timestamp with internal timezone is used.
15.	No varchar(max) or varbinary(max) is available.	Varchar(max) and varbinary(max) is used.	Varchar(max) and varbinary(max) is used.
16.	No table datatype is included.	No table datatype is included.	Table datatype introduced.
17.	No SSIS is included.	SSIS is started using.	SSIS avails in this version
18.	CMS is not available.	CMS is not available.	Central Management Server (CMS) is Introduced.
19.	PBM is not available.	PBM is not available.	Policy based management (PBM) server is Introduced.

In further posts we will discuss basic things in SQL Server like about SQL Server Architecture, System/Users Databases, Creation of database and some of the database properties.