SQL server 2005 vs sqlserver 2008

Question

Hi all What is the difference between SQL server 2005 and sqlserver 2008 ?

Rohatash Kumar · Answer

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} SQL SERVER 2005: 1.Both are combined as SSMS(Sql Server management Studio). 2.XML datatype is introduced. 3.We can create 2(pow(20))-1 databases. 4.Exception Handling 5.Varchar(Max) data type 6.DDL Triggers 7.DataBase Mirroring 8.RowNumber function for paging 9.Table fragmentation 10.Full Text Search 11.Bulk Copy Update 12.Cant encrypt 13.Can Compress tables and indexes.(Introduced in 2005 SP2) 14.Datetime is used for both date and time. 15.Varchar(max) and varbinary(max) is used. 16.No table datatype is included. 17.SSIS is started using. 18.CMS is not available. 19.PBM is not available. SQL SERVER 2008: 1.Both are combined as SSMS(Sql Server management Studio). 2.XML datatype is used. 3.We can create 2(pow(20))-1 databases. 4.Exception Handling 5.Varchar(Max) data type 6.DDL Triggers 7.DataBase Mirroring 8.RowNumber function for paging 9.Table fragmentation 10.Full Text Search 11.Bulk Copy Update 12.Can encrypt the entire database introduced in 2008. 13.Can compress tables and indexes. 14.Date and time are seperately used for date and time datatype geospatial and timestamp with internal timezone is used. 15.Varchar(max) and varbinary(max) is used. 16.Table datatype introduced. 17.SSIS avails in this version. 18.Central Management Server(CMS) is Introduced. 19.Policy based management(PBM) server is Introduced.

Vulpes · Answer

I'd check out the new features in SQL Server 2008 and SQL Server 2008 R2 enumerated in this Wikipedia article ( http://en.wikipedia.org/wiki/Microsoft_SQL_Server ) which is as good a summary as any.