SQLServerUpdates.com
  • Home – Most Recent Updates
    • SQL Server 2019 Updates
    • SQL Server 2017 Updates
    • SQL Server 2016 Updates
    • SQL Server 2014 Updates
    • SQL Server 2012 Updates
    • SQL Server 2008 R2 Updates
    • SQL Server 2008 Updates
  • Download SQL Server
  • Subscribe to Updates
  • Contact Us
    • Frequently Asked Questions

SQL Server 2016 SP1 Out: Standard Edition has some Enterprise Edition Features

6 years ago
Brent Ozar
Updates
21 Comments

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.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
SQL Server 2014 SP2 CU2 Released
Next Post
SQL Server 2014 SP2 CU4, SP1 CU11 Released

21 Comments. Leave new

  • Muhammad Asam
    November 16, 2016 10:29 pm

    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

    Reply
  • Glenn Berry
    November 17, 2016 2:31 pm

    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.

    Reply
    • Brent Ozar
      November 17, 2016 2:48 pm

      Wat

      Next you’re going to tell me you can’t create indexes online either?

      Reply
      • Glenn Berry
        November 17, 2016 3:04 pm

        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.

        Reply
        • Brent Ozar
          November 17, 2016 3:09 pm

          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.

          Reply
          • Mike Rawald
            November 17, 2016 4:44 pm

            Yay, WtF & Huh?? Such an emotional rollercoaster..

  • Mark Freeman
    November 17, 2016 3:32 pm

    Is there a post somewhere that definitively lists which specific Enterprise Edition features are and are not now available in 2016 SP1?

    Reply
    • Brent Ozar
      November 17, 2016 3:48 pm

      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.

      Reply
  • Matt
    November 18, 2016 10:38 am

    That’s great news 🙂

    Do you know if it applies to SSRS features as well? Specifically, data-driven subscriptions?

    Thanks,

    Matt

    Reply
    • Brent Ozar
      November 18, 2016 3:16 pm

      No, sorry.

      Reply
      • Matt
        November 18, 2016 7:27 pm

        Never mind….thanks, anyway 🙂

        Reply
        • Bob Edgson
          November 18, 2016 9:32 pm

          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

          Reply
  • Bill Portman
    January 4, 2017 9:05 pm

    Encryption is not supported, ugh.

    Reply
  • Shawn Yang
    March 8, 2017 10:01 pm

    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!

    Reply
    • Brent Ozar
      March 8, 2017 10:03 pm

      Shawn – you’ve already posted this question at Stack Exchange. Go ahead and work with the answers over there. Thanks!

      Reply
      • shawn yang
        March 8, 2017 10:30 pm

        My question has been deleted from Stack Exchange, because of “Thanks!” being included along with my question (?)

        Can you answer the question here?

        Thanks!

        Reply
        • Brent Ozar
          March 8, 2017 10:32 pm

          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.

          Reply
  • Cobra
    May 24, 2017 12:12 pm

    Don’t forget about perspectives, Data Driven Subcriptions and Semi-additive measures

    Reply
  • John
    March 8, 2018 12:04 pm

    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/

    Reply
    • Brent Ozar
      March 8, 2018 12:05 pm

      Great catch! Updated. Thanks!

      Reply
  • Guy Stephens
    February 26, 2019 7:47 am

    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?

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Subscribe

Want to get an email when Microsoft publishes a new SP or CU for SQL Server? Subscribe here.

Recent Updates

  • SQL Server 2022 Gets Its 2nd Update in 2 Days February 16, 2023
  • SQL Server 2022 Gets Its First Update! Plus 2019, 2017, 2016, 2014 Updates February 14, 2023
  • Announcing SQL Server 2019 CU15 January 27, 2022
  • Announcing SQL Server 2019 CU13 and SSMS 18.10: Replication Improvements October 5, 2021
  • Announcing 2016 Service Pack 3 and 2017 CU26 September 15, 2021

© 2021 Brent Ozar Unlimited®. All Rights Reserved. Privacy Policy