Big news at today’s Microsoft Connect conference: Service Pack 1 is out.
The list of features is awesome, but here’s the biggest news: almost all of the developer-friendly features of Enterprise Edition are now available in Standard Edition. That’s right: it’s time to get jiggy with the partitioning, compression, and more.
There’s one big restriction: for more than 4 sockets, more than 24 cores, or more than 128GB RAM, you’ll need Enterprise Edition.
21 Comments. Leave new
What a Joke!!!
“There’s one big restriction: for more than 4 sockets, more than 24 cores, or more than 128GB RAM, you’ll need Enterprise Edition.”
Anyone who is using 128GB RAM do they really need Enterprise Edition? May be for learning purpose only as a developer.
Thanks for sharing.
Cheers
Unfortunately, online index rebuilds are not in SQL Server 2016 Standard Edition, even with SP1. If you try it, you will get this:
Msg 1712, Level 16, State 1, Line 5
Online index operations can only be performed in Enterprise edition of SQL Server.
Wat
Next you’re going to tell me you can’t create indexes online either?
That would be affirmative. The SSMS 16.5 GUI even greys out that option. If you try to just do it yourself in T-SQL, you get the same error.
LOLWUT
Alright, what dim bulbs told MS that developers were desperate for partitioning in Standard Edition, but didn’t need to create or rebuild indexes? Just wow.
Yay, WtF & Huh?? Such an emotional rollercoaster..
Is there a post somewhere that definitively lists which specific Enterprise Edition features are and are not now available in 2016 SP1?
Yeah, MS has a couple on the Release Services blog, but they’re not accurate either – for example, they say Stretch Database was removed from Standard Edition.
That’s great news 🙂
Do you know if it applies to SSRS features as well? Specifically, data-driven subscriptions?
Thanks,
Matt
No, sorry.
Never mind….thanks, anyway 🙂
This TechNet blog seems to cover most features https://technet.microsoft.com/en-gb/windows/cc645993(v=sql.90)# SSRS features link is down the page and implies data driven subscriptions are enterprise only.
but there are aways to emulate data driven subscriptions with a bit of sideways thinking just not straight of of the box
Encryption is not supported, ugh.
Hello Brent,
My question is can we restore a SQL 2008 R2 enterprise database (with page compression applied) into SQL 2016 SP1 standard edition?
Thanks!
Shawn – you’ve already posted this question at Stack Exchange. Go ahead and work with the answers over there. Thanks!
My question has been deleted from Stack Exchange, because of “Thanks!” being included along with my question (?)
Can you answer the question here?
Thanks!
Only the answer was deleted. Your question is still here:
http://dba.stackexchange.com/questions/158670/upgrade-from-sql-server-2008-r2-enterprise-to-sql-server-2016-standard-edition
Please don’t respond further here. Feel free to work with folks over at Stack. Thanks for your understanding.
Don’t forget about perspectives, Data Driven Subcriptions and Semi-additive measures
You should edit this post to remove the incorrect claim that SQL 2016 Standard Edition SP1 supports online index rebuilds. As it is the main claim of your post, it makes the entirety of this to be false.
See the complete list features added here:
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/
Great catch! Updated. Thanks!
If there is one thing SQL Standard users need, it is online index rebuilds. Literally nothing else.
Is there any mechanism to petition Microsoft for this? Surely they are getting this feedback from someone?