Differences between SQL Server 2008 and SQL Server 2008 R2

Question

Differences between SQL Server 2008 and SQL Server 2008 R2

Patti Johnson

SSCertifiable

Points: 7054
More actions
June 8, 2010 at 9:41 am

#225455

Does anyone know the differences between SQL Server 2008 and SQL Server 2008 R2?

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

http://www.google.com/search?q=new+features+%22SQL+2008+R2%22

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Patti Johnson SSCertifiable Points: 7054 More actions · Answer 2

Thanks Gail for the link. My question was not new features but differences between SQL 2008 and SQL 2008 R2. 🙂 Thank you for your help. You are much more experience in SQL Server than I am.

Patti Johnson SSCertifiable Points: 7054 More actions · Answer 3

So Does anyone have any experience with SQL 2008 to know the differences between SQL 2008 and SQL 2008 R2?

Thank you for your time and willingness to share.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Patricia Johnson (6/8/2010)
So Does anyone have any experience with SQL 2008 to know the differences between SQL 2008 and SQL 2008 R2?
Thank you for your time and willingness to share.

What the heck else do you need besides the paper from MS explaining the differences which is the first link in Google?

Patti Johnson SSCertifiable Points: 7054 More actions · Answer 5

Patti Johnson

SSCertifiable

Points: 7054

June 8, 2010 at 10:28 am

#1177560

I'm sorry. Maybe I didn't see it.

Patti Johnson SSCertifiable Points: 7054 More actions · Answer 6

Here is what I do receive.

Hopefully I have attached what I see.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Um, how about the first two links?

The reason they don't say anything about changes (assuming you've read them), is because R2 is a whole set of add-ons. There are virtually no changes to the DB engine in R2, just new features and tools.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sgalbra Mr or Mrs. 500 Points: 556 More actions · Answer 8

Those webpages were created by salesman. I think we are looking for technical reference documents.

cathy.baker Hall of Fame Points: 3412 More actions · Answer 9

I am currently using SQL 2008 (I have both standard and enterprise editions) with SP1. Do I need to re-license my SQL 2008 products to use SQL 2008 R2?

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

R2 is a new version (like 2008 from 2005) and new licences must be purchased if you wish to upgrade.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 11

If you don't have insurrance, then yes. I don't know if you can get a discount tho... I never explored that option.