Solved

Standard Edition differences

Posted on 2010-08-21
3
475 Views
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?
0
Comment
Question by:sqlserverdba
3 Comments
 
LVL 6

Accepted Solution

by:
CorpComp earned 42 total points
ID: 33494071
0
 
LVL 58

Assisted Solution

by:cyberkiwi
cyberkiwi earned 42 total points
ID: 33494513
Backup compression has been in 2008 since pre-R2.
R2 adds very little to the database engine http://msdn.microsoft.com/en-us/library/bb510411.aspx
Most of the changes were around the value-add periphery from the previous expert's link.
0
 
LVL 5

Assisted Solution

by:ThakurVinay
ThakurVinay earned 41 total points
ID: 33500009
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard 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.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

746 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

10 Experts available now in Live!

Get 1:1 Help Now