Do I need SQL Server Enterprise or Standard?

What is the difference between SQL Server Standard and Enterprise?

Like the Standard edition, Enterprise includes basic auditing, contained databases, encryption and backups, and user-defined roles. It surpasses the Standard edition with its inclusion of fine grained auditing, transparent database encryption, and extensible key management.

Do I need SQL Server Enterprise?

SQL Server Reporting Services is available in both editions, however if you want to use Data-Driven subscriptions or a scale-out deployment, you'll need Enterprise Edition. Standard Edition simply doesn't have those capabilities.

Which edition of SQL Server should I use?

You use Standard Edition – because it supports 128GB RAM (and can even go beyond that for some internal stuff like query plans.) You want to stay here until 2025-2026 – this version has more years left in its support life than SQL Server 2012/2014, so you can install it once and stick around longer.

What is difference between Enterprise Edition and Standard Edition?

While the Enterprise edition of SQL Server 2016 does support a wide array of data warehouse features, the Standard edition only supports standard algorithms and data mining tools (Wizards, Editors, Query Builders).