Standard Edition differences

Posted on 2010-08-21
Last Modified: 2012-05-10
what are the differences between Standard Edition SQL Server 2008 and Standard Edition SQL Server 2008 R2? is it just backup compression? or any other key improvements?
Question by:sqlserverdba

Accepted Solution

CorpComp earned 42 total points
ID: 33494071
LVL 58

Assisted Solution

cyberkiwi earned 42 total points
ID: 33494513
Backup compression has been in 2008 since pre-R2.
R2 adds very little to the database engine
Most of the changes were around the value-add periphery from the previous expert's link.

Assisted Solution

ThakurVinay earned 41 total points
ID: 33500009

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Sending a Secure fax is easy with eFax Corporate ( First, just open a new email message. In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now