difference between SQL Server versions

Question

difference between SQL Server versions

HBK_4700

SSCrazy Eights

Points: 8932
More actions
December 15, 2011 at 10:01 am

#261913

Hi,
Is there any Microsoft link that I can find the difference between all SQL versions and features.
ex: sql server standard edition vs sql server developer edition
Thanks..

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 1

Google "SQL Server Editions" without the quotes plus whichever SQL Server version (2008, 2008 R2, 2012) you want to see.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 2

My google-foo is strong..

Google Search terms:

SQL 2008 compare editions

On the first page:

http://msdn.microsoft.com/en-us/library/cc645993.aspx

CEWII

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

Elliott Whitlow (12/15/2011)
My google-foo is strong..
Google Search terms:
SQL 2008 compare editions
On the first page:
http://msdn.microsoft.com/en-us/library/cc645993.aspx
CEWII

Even Better 'Compare Microsoft SQL Server Editions'

http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

Elliott Whitlow

SSC Guru

Points: 102402

December 15, 2011 at 10:17 am

#1422090

I could go with that..

CEWII

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 5

You can find out here

http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 6

Also this can be helpful too

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

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107186

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

What is this "nill" feature of SQL Server 2000? I want it too! 🙂

edit: that list is a bit short. Spatial data is not mentioned, the FOR XML PATH is also forgotten and most of the BI features are left out. SQL Server 2000 doesn't have SSIS, but it did had DTS (the predecessor).

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 8

SQlLogic

SSCrazy Eights

Points: 9686

December 16, 2011 at 7:46 am

#1422514

that's why it says No SSIS Included..

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

logicinside22 (12/16/2011)
that's why it says No SSIS Included..

But it doesn't say DTS included...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

feedback.mail.me Valued Member Points: 68 More actions · Answer 10

Hi,

I found the following article while searching for differences between various versions of SQL Server.

Here is the link. It may be useful for you.

http://learnsqltips.blogspot.com/2012/01/introduction-to-sql-server.html