Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
diwakar_m
Starting Member
19 Posts |
Posted - 2008-07-23 : 02:05:28
|
Can someone list the differences between SQL Server 2000 , 2005 and 2008? |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-23 : 03:35:55
|
In what aspect?At a first glance they have different product names, thaat's for sure. E 12°55'05.25"N 56°04'39.16" |
|
|
diwakar_m
Starting Member
19 Posts |
Posted - 2008-07-23 : 05:30:54
|
The difference should be based on their features.Or you can imagine yourself in the shoes of an interviewee, what would you tell the interviwer if he throws this question at you? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
sathish
Starting Member
1 Post |
Posted - 2010-11-12 : 00:07:45
|
--Reference:http://stackoverflow.com/questions/198478/advantages-of-ms-sql-server-2008-over-ms-sql-server-2005SQL SERVER 2000:1.Query Analyser and Enterprise manager are separate.2.No XML datatype is used.3.We can create maximum of 65,535 databases.4.Nill5.Nill6.Nill7.Nill8.Nill9.Nill10.Nill11.Nill12.Nill13.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 Handling5.Varchar(Max) data type6.DDL Triggers7.DataBase Mirroring8.RowNumber function for paging9.Table fragmentation10.Full Text Search11.Bulk Copy Update12.Cant encrypt13.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 Handling5.Varchar(Max) data type6.DDL Triggers7.DataBase Mirroring8.RowNumber function for paging9.Table fragmentation10.Full Text Search11.Bulk Copy Update12.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=158214.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. -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.aspx19.Policy based management(PBM) server is Introduced. -http://www.mssqltips.com/tip.asp?tip=1492 -http://msdn.microsoft.com/en-us/library/bb510667.aspxWith regards,sathishsql |
|
|
pathan
Starting Member
3 Posts |
Posted - 2012-10-11 : 05:42:00
|
Hi,Can any body tell the differences b/w (Sql Server 2000, Sql Server 2005, Sql Server 2008, Sql Server 2008 R2 and Sql Server 2012...)its very urgent dude...Revert me as soon as possible.Thanks in advance.Thanks and Regards,Pathan... |
|
|
|
|
|
|
|