Main differences between SQL Server 2000 and 2008

PROBLEM:

You are a developer, you want more database programming capabilities, why to upgrade from SQL Server 2000 to 2008?

SOLUTION:

The following is a list of the main differences

Sql Server 2000	Sql Server 2005	Sql Server 2008
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)
No XML datatype is used	XML datatype is introduced	XML datatype is used
N/A	Exception Handling	Exception Handling
N/A	Varchar(Max) data type	Varchar(Max) data type
N/A	DDL Triggers	DDL Triggers
N/A	DataBase Mirroring	DataBase Mirroring
N/A	RowNumber function for paging	RowNumber function for paging
N/A	Table fragmentation	Table fragmentation
N/A	Full Text Search	Full Text Search
N/A	Bulk Copy Update	Bulk Copy Update
N/A	Cant encrypt	Can encrypt the entire database introduced in 2008
Cant compress the tables and indexes	Can Compress tables and indexes (Introduced in 2005 SP2)	Can compress tables and indexes
Datetime datatype is used for both date and time	Datetime is used for both date and time	Date and time are seperately used for date and time datatype, geospatial, timestamp, timezone  is used
No varchar(max) or varbinary(max) is available	Varchar(max) and varbinary(max) is used	Varchar(max) and varbinary(max) is used
No table datatype is included	No table datatype is included	Table datatype introduced
No SSIS is included	SSIS is started using	SSIS avails in this version
CMS is not available	CMS is not available	Central Management Server(CMS) is Introduced
PBM is not available	PBM is not available	Policy based management(PBM) server is Introduced
PIVOT and UNPIVOT functions are not used	PIVOT and UNPIVOT functions are used	PIVOT and UNPIVOT functions are used

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!