Differences between SQL2000,SQL2005 and SQL2008.


S.No
SQL 2000
SQL2005
SQL2008
1
Query Analyzer and Enterprise Manager are separate.
Both are combined as SQL SERVER MANAGEMEN STUDIO.
Both are combined as SQL SERVER MANAGEMEN STUDIO.
2
No XML datatype is used.
XML datatype is introduced.
XML datatype is used.
3
65,535 databases can be created.
2(pow(20))-1 databases can be created.
2(pow(20))-1 databases can be created.
4
Nill
Exception handling
Exception handling
5
Nill
Varchar(Max) datatype
Varchar(Max) datatype
6
Nill
DDL Triggers
DDL Triggers
7
Nill
Database mirroring
Database mirroring
8
Nill
Row number function for paging use.
Row number function for paging use.
9
Nill
Table fragmentation
Table fragmentation
10
Nill
Full text search
Full text search
11
Nill
Bulk copy update
Bulk copy update
12
Nill
Can’t encrypt
Can encrypt entire database
13
Compression not possible
Can compress tables and indexes(introduced in 2005 SP2)
Can compress tables and indexes
14
Datetime is used for both date and time
Datetime is used for both date and time
Date and time are separately used for date and time datatype
15
Nill
Narchar(max) and varbinary(max) is used.
Narchar(max) and varbinary(max) is used.
16
Nill
Nill
Table datatype is introduced.
17
Nill
 SSIS is used.
SSIS is used.
18
Nill
Nill
Central Management Server(CMS) is introduced.
19
Nill
Nill
Policy based management is available.

Comments

Post a Comment

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)