September 20, 2013 at 9:25 am
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
September 20, 2013 at 9:40 am
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/
September 21, 2013 at 4:10 pm
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]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply