SQL Server 2008 r2 Standard Edition vs SQL Server 2012 Standard Edition

• dbadude78

  Ten Centuries

  Points: 1243

  More actions

  September 20, 2013 at 9:25 am

  #282857

  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

• Sean Lange

  SSC Guru

  Points: 286601

  More actions

  September 20, 2013 at 9:40 am

  #1651967

  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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  September 21, 2013 at 4:10 pm

  #1652159

  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.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]