Wednesday, April 30, 2014

Difference between SqlServer 2000/2005/2008

SQL Server 2000 SQL Server 205 SQL serevr 2012
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.Nil 4.Exception Handling 4.Exception Handling
5.Nil 5.Varchar(Max) data type 5.Varchar(Max) data type
6.Nil 6.DDL Triggers 6.DDL Triggers
7.Nil 7.DataBase Mirroring 7.DataBase Mirroring
8.Nil 8.RowNumber function for paging 8.RowNumber function for paging
9.Nil 9.Table fragmentation 9.Table fragmentation
10.Nil 10.Full Text Search 10.Full Text Search
11.Nil 11.Bulk Copy Update 11.Bulk Copy Update
12.Nil 12.Cant encrypt 12.Can encrypt the entire database introduced in 2008.
13.cant compress the tables and indexes. 13.Can Compress tables and indexes.(Introduced in 2005 SP2) 13.Can compress tables and indexes.
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.
19.PBM is not available. 19.PBM is not available. 19.Policy based management(PBM) server is Introduced.
Thanks
GSV

No comments: