Sep 16, 2011

Diffrence between SQL Server 2000,2005 and 2008







SlSQL Server 2000SQL Server 2005SQL Server 2008
1Query
Analyser and Enterprise manager are separate.


Both are
combined as SSMS(Sql Server management Studio).


Both are
combined as SSMS(Sql Server management Studio).
2No
XML datatype is used.
XML
datatype is introduced.
XML
datatype is used.
3We
can create maximum of 65,535 databases.
We
can create 2(pow(20))-1 databases.
We
can create 2(pow(20))-1 databases.
4NillException
Handling
Exception
Handling
5NillVarchar(Max)
data type
Varchar(Max)
data type
6NillDDL
Triggers
DDL
Triggers
7NillDataBase
Mirroring
DataBase
Mirroring
8NillRowNumber
function for paging
RowNumber
function for paging
9NillTable
fragmentation
Table
fragmentation
10NillFull
Text Search
Full
Text Search
11NillBulk
Copy Update
Bulk
Copy Update
12NillCant
encrypt
Can
encrypt the entire database introduced in 2008.
13Cant
compress the tables and indexes.
Can
Compress tables and indexes.(Introduced in 2005 SP2)
Can
compress tables and indexes.
14Datetime
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 and
timestamp with internal timezone is used.
15No
varchar(max) or varbinary(max) is available.
Varchar(max)
and varbinary(max) is used.
Varchar(max)
and varbinary(max) is used.
16No
table datatype is included.
No
table datatype is included.
Table
datatype introduced.
17No
SSIS is included.
SSIS
is started using.
SSIS
avails in this version.
18CMS
is not available.
CMS
is not available.
Central
Management Server(CMS) is Introduced.
19PBM
is not available.
PBM
is not available.
Policy
based management(PBM) server is Introduced.