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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 The Naming and Positioning of R2?

Author  Topic 

Kristen
Test

22859 Posts

Posted - 2010-07-14 : 05:14:41
Is it just me?

Is SQL 2008 R2 just a minor upgrade / patch or a different version?

Why didn't they call it SQL2010?

It strikes me as being as daft as the maverick names TEXT becoming VARCHAR(MAX) and DATETIME2 used instead of LONGDATETIME

I'm just downloading BoL for SQL2008 R2 and it says it will overwrite my SQl2008 BoL - and if I want SQL2008 BoL back I have to uninstall SQL2008 R2 BoL.

Do they not think that people will need to support both?

Kristen
Test

22859 Posts

Posted - 2010-07-14 : 05:16:31
Hahaha ... and the Download for SQL2008 BoL says:

"Overview
SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008.
"

which is only going to further confuse people IMHO ...
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-07-14 : 05:20:53
R2 is version 10.5 and database internal version is 6.61. This is important because you cannot "downgrade" a R2 database to SQL Server 2008 (version 10.0 and internal database version 6.55).

So, it's a new product but not a major release.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-07-14 : 05:25:03
Like in the old days when SQL6 became SQL6.5 then. Marketing should leave the programmers to decide some of this stuff.
Go to Top of Page

mikebird
Aged Yak Warrior

529 Posts

Posted - 2010-07-15 : 05:28:22
2000 was yucky!
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-15 : 06:26:22
quote:
Originally posted by Kristen

Is SQL 2008 R2 just a minor upgrade / patch or a different version?


Different version. Minor release, not enough changes to warrant a new name.

quote:
Why didn't they call it SQL2010?

Windows Server 2003, Windows Server 2003 R2
Windows Server 2008, Windows Server 2008 R2

quote:
I'm just downloading BoL for SQL2008 R2 and it says it will overwrite my SQl2008 BoL - and if I want SQL2008 BoL back I have to uninstall SQL2008 R2 BoL.

Do they not think that people will need to support both?


There's virtually no changes to the database engine, so no major worries there. Most of R2 are additional features and add-ons.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-07-15 : 07:04:58
They even share the same compatibility level, 100.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-07-15 : 07:35:04
That has to be a bug, surely?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-07-15 : 07:36:24
No. As gail writes, there is virtually no changes in the database engine.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-07-15 : 07:56:37
"virtually"

Ho hum ...
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-15 : 08:35:38
3 changes, if I recall.
Unicode compression is one. Other two I believe are just bug fixes. In terms of the database engine itself, it's pretty much 2008 with a new name, higher price and different version limitation.

It's a release of add-ons. Stream insight, MDM, DACPAC, control points, powerpivot, whatever else they tossed in.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-07-15 : 08:46:38
To be fair, Microsoft also released backup compression to Standard Edition (2008R2).


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -