SQL SERVER Differences 2000,2005 and 2008
SQL SERVER 2000
|
SQL SERVER 2005
|
SQL SERVER 2008
|
1.Query Analyser and Enterprise manager are separate.
|
1.Both are combined as SSMS(Sql Server management Studio).
|
1.Both are combined as SSMS(Sql Server management Studio).
|
2.No XML datatype is used.
|
2.XML datatype is introduced.
|
2.XML datatype is used.
|
3.We can create maximum of 65,535 databases.
|
3.We can create 2(pow(20))-1 databases.
|
3.We can create 2(pow(20))-1 databases.
|
4.Nill
|
4.Exception Handling
|
4.Exception Handling
|
5.Nill
|
5.Varchar(Max) data type
|
5.Varchar(Max) data type
|
6.Nill
|
6.DDL Triggers
|
6.DDL Triggers
|
7.Nill
|
7.DataBase Mirroring
|
7.DataBase Mirroring
|
8.Nill
|
8.RowNumber function for paging
|
8.RowNumber function for paging
|
9.Nill
|
9.Table fragmentation
|
9.Table fragmentation
|
10.Nill
|
10.Full Text Search
|
10.Full Text Search
|
11.Nill
|
11.Bulk Copy Update
|
11.Bulk Copy Update
|
12.Nill
|
12.Cant encrypt
|
12.Can encrypt the entire database introduced in 2008.
--check
it(http://technet.microsoft.com/en-us/library/cc278098(SQL.100).aspx)
(http://www.sqlservercentral.com/articles/Administration/implementing_efs/870/)
(http://www.kodyaz.com/articles/sql-server-2005-database-encryption-step-by-step.aspx)
(http://www.sql-server-performance.com/articles/dev/encryption_2005_1_p1.aspx)
(http://geekswithblogs.net/chrisfalter/archive/2008/05/08/encrypt-documents-with-sql-server.aspx)
|
13.cant compress the tables and indexes.
|
13.Can Compress tables and indexes.(Introduced in 2005 SP2)
|
13.Can compress tables and indexes. -http://www.mssqltips.com/tip.asp?tip=1582
|
14.Datetime datatype is used for both date and time.
|
14.Datetime is used for both date and time.
|
14.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.
|
15.Varchar(max) and varbinary(max) is used.
|
15.Varchar(max) and varbinary(max) is used.
|
16.No table datatype is included.
|
16.No table datatype is included.
|
16.Table datatype introduced.
|
17.No SSIS is included.
|
17.SSIS is started using.
|
17.SSIS avails in this version
|
18.CMS is not available.
|
18.CMS is not available.
|
18.Central Management Server(CMS) is Introduced.
-http://msdn.microsoft.com/en-us/library/bb934126.aspx
-http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-Central-Management-Servers-have-you-seen-these.aspx
|
19.PBM is not available.
|
19.PBM is not available.
|
19.Policy based management(PBM) server is Introduced. -http://www.mssqltips.com/tip.asp?tip=1492
-http://msdn.microsoft.com/en-us/library/bb510667.aspx
|
No comments:
Post a Comment