Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 r2 Standard Edition vs SQL Server 2012 Standard Edition Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 9:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 34, Visits: 577
Hi Guys,

I need to find out the difference between SQL Server 2008 r2 STD and SQL Server 2012 STD in terms of features, admistration tools, BI tools etc.

As we all know Enterprise has all the features that most people would like, but, is there any major differences between the two ?

I have been on the MS SQL website and found most new features are not on the STD edition.

Any help would be really appreciated
Post #1496935
Posted Friday, September 20, 2013 9:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
You will have to do a little bit of manual work to compare what features are available by edition across the versions but this will show all the features and which edition they are available in.

http://msdn.microsoft.com/en-us/library/cc645993.aspx


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1496940
Posted Saturday, September 21, 2013 4:10 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 21, 2014 3:04 PM
Points: 801, Visits: 715
If you look at the promotion material from Microsoft, it seems that the really hot stuff - Availability Groups and Columnstore indexes - are only in Enterprise.

However, what really is a the major improvement is in all edition, to wit the window functions that permits you write expressions for running sums easily and efficiently. Nor should we forget try_convert and try_cast which are small things that are extremely valueable for a programmer.


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1497169
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse