Diff b/w sqlserver 2005 and 2008

Question

In sharepoint interviews all the people are asking abt what is the diff between 2005 and 2008? can any one tell abt the diff in sharepoint wise and sqlserver development wise

Senthilkumar · Answer

Hi SQL SERVER 2000: 1.Query Analyser and Enterprise manager are separate. 2.No XML datatype is used. 3.We can create maximum of 65535 databases. 4.Nill 5.Nill 6.Nill 7.Nill 8.Nill 9.Nill 10.Nill 11.Nill 12.Nill 13.cant compress the tables and indexes. 14.Datetime datatype is used for both date and time. 15.No varchar(max) or varbinary(max) is available. 16.No table datatype is included. 17.No SSIS is included. 18.CMS is not available. 19.PBM is not available. 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. --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.Can compress tables and indexes. -http://www.mssqltips.com/tip.asp?tip=1582 14.Date and time are seperately used for date and time datatypegeospatial 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. -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.Policy based management(PBM) server is Introduced. -http://www.mssqltips.com/tip.asp?tip=1492 -http://msdn.microsoft.com/en-us/library/bb510667.aspx Refer this url also: http://www.angryhacker.com/blog/archive/2008/06/20/10-reasons-why-sql-server-2008-is-going-to-rock.aspx