SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Differences between SQL Server 2000, 2005 and 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

diwakar_m
Starting Member

19 Posts

Posted - 07/23/2008 :  02:05:28  Show Profile  Reply with Quote
Can someone list the differences between SQL Server 2000 , 2005 and 2008?

SwePeso
Patron Saint of Lost Yaks

Sweden
30242 Posts

Posted - 07/23/2008 :  03:35:55  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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"
Go to Top of Page

diwakar_m
Starting Member

19 Posts

Posted - 07/23/2008 :  05:30:54  Show Profile  Reply with Quote
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?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30242 Posts

Posted - 07/23/2008 :  05:52:14  Show Profile  Visit SwePeso's Homepage  Reply with Quote
That's better. Now I at least know some background of your query.

All about SQL Server can be found here
http://www.microsoft.com/sql/default.mspx



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

sathish
Starting Member

India
1 Posts

Posted - 11/12/2010 :  00:07:45  Show Profile  Reply with Quote
--Reference:
http://stackoverflow.com/questions/198478/advantages-of-ms-sql-server-2008-over-ms-sql-server-2005

SQL 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.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 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.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

With regards,
sathishsql
Go to Top of Page

pathan
Starting Member

India
3 Posts

Posted - 10/11/2012 :  05:42:00  Show Profile  Reply with Quote
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...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000