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 LONGDATETIMEI'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:"OverviewSQL 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 ... |
 |
|
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" |
 |
|
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. |
 |
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-07-15 : 05:28:22
|
2000 was yucky! |
 |
|
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 R2Windows Server 2008, Windows Server 2008 R2quote: 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 ShawSQL Server MVP |
 |
|
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" |
 |
|
Kristen
Test
22859 Posts |
Posted - 2010-07-15 : 07:35:04
|
That has to be a bug, surely? |
 |
|
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" |
 |
|
Kristen
Test
22859 Posts |
Posted - 2010-07-15 : 07:56:37
|
"virtually"Ho hum ... |
 |
|
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 ShawSQL Server MVP |
 |
|
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" |
 |
|
|