Is SQL 2014 Buffer Pool Extension an Enterprise Edition only feature?

No, it’s not. It’s on Standard too. If an attempt is made to enable it on any other edition, you’ll see error 865 written to ERRORLOG “Buffer pool extension is only supported on Standard and Enterprise Editions of SQL Server.” and the same exception is raised aborting the ALTER SERVER CONFIGURATION statement. It’s also worth…

0

How the density and distribution of data in the leading key column of an index affects the degree of parallelism chosen for index operations targeting that index?

There’s a topic in SQL Server’s documentation whose title is Configuring Parallel Index Operations, which mentions that the Database Engine can reduce the degree of parallelism if the leading key column of a non-partitioned index has a limited number of distinct values or the frequency of each distinct value varies significantly. What does that exactly…

3

What’s in Enterprise only? (Change Data Capture)

Starting with version 2008, SQL Server introduced a feature called Change Data Capture which provides information about DML changes on a table and a database. Change Data Capture eliminates the need to use expensive techniques such as user triggers, timestamp columns, and join queries to determine what changes have affected a given table. However, CDC…

0

What’s in Enterprise only? (Transparent Data Encryption)

Starting with version 2008, SQL Server solves the problem of protecting data at rest, encrypting databases both on the hard drive and consequently on backup media. To benefit from this out of the box functionality though, you must be running the Enterprise edition (or a Developer Edition or an Evaluation Edition, both of which behave…

0

What’s in Enterprise only? (Database Snapshot)

If you require one or more read-only, static views of a database, which is transactionally consistent with the source database at the moment the static view was created, beginning with SQL Server 2005 you can take advantage of Database Snapshots, which is only available in Enterprise Edition (or a Developer Edition or an Evaluation Edition,…

0

What’s in Enterprise only? (Support for Data Compression & Vardecimal Storage Format)

Starting with version 2008, SQL Server supports both row and page compression for both tables and indexes. Also SQL Server 2008 R2 continues to support, although it has been deprecated, the vardecimal storage format that was introduced with SQL Server 2005 Service Pack 2. However, because row-level compression achieves the same goals, the vardecimal storage…

0

What’s in Enterprise only? (Up to 8 CPU sockets)

Each edition of SQL Server supports a specified number of processor sockets multiplied by the number of logical CPUs in each socket. The Enterprise Edition of SQL Server supports up to 8 CPU sockets, while the Standard only supports up to 4. All this means is that, in a machine equipped with over 4 CPU…

0

What’s in Enterprise only? (Fuzzy Lookup Transformation in Integration Services)

Fuzzy Lookup is a component which, when used as part of a data flow in an SSIS (SQL Server Integration Services) package, enables you to locate matching records in a reference table just like the standard Lookup transformation does, with the added value that it can also lookup close matches and not only those which…

0

What’s in Enterprise only? (Hot add CPU)

Starting with SQL Server 2008 the product supports the ability to start using or stop using CPUs that are dynamically added or removed to a running system, either physically, logically (by online hardware partitioning), or virtually through a virtualization layer. Only the Enterprise Edition (or a Developer Edition or an Evaluation Edition, both of which…

0

What’s in Enterprise only? (View Substitution Implicitly Allowed)

As with any index, SQL Server can decide to use an indexed view (materialized views) in its query plan only if the query optimizer determines it is beneficial to do so. Indexed views can be created in any edition of SQL Server. But only in the Enterprise Edition, the query optimizer automatically considers the indexed…

0