July 12, 2023 at 1:00 pm
Hi all,
I have not worked in Standard edition in a while (Enterprise only), but a new client of ours only wants Standard edition installed.
I know of the main differences between Std and Ent (such as hardware, AO groups, etc.). But I was mostly wondering if there are any TSQL specific commands / table design features / data types, etc. that are available in Ent but not in Std edition?
Thanks
July 12, 2023 at 1:10 pm
July 12, 2023 at 1:14 pm
Not at that level.
I believe ONLINE create/rebuild of indexes is not available in standard.
If you're on SQL 2016 on above, data compression is still available.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
July 12, 2023 at 1:53 pm
thank you
I just came across this table sys.dm_db_persisted_sku_features
Which looks like it could be what I was looking for
July 19, 2023 at 7:34 am
I guess your client may be looking at workload and thinking Standard Edition will do.
Both they and you should look at BCO and what SLAs they want for RTO and RPO and how this might be achieved with Standard and Enterprise. For me, the Availability Group options in Enterprise justify the extra cost. The additional ease of operation with online operations are a wonderful great free bonus, but BCO capability is the killer app that makes Enterprise worth paying for.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply