Home > SQL server DBA administration > How do I know which advanced futures are used in Database at SQL 2008 enterprise edition

How do I know which advanced futures are used in Database at SQL 2008 enterprise edition


As we are know that all futures are available at enterprise edition but the same will not available at standard edition. Due to business requirement if we have to move the database enterprise to standard then It can be important to know which Enterprise features have been enabled. To retrieve details of which SQL Server Enterprise functions have been enabled, you just need to issue the simple SQL statement given here:

 

SELECT * FROM sys.dm_db_persisted_sku_features( Only applicable at SQL 2008 also)

 

Futures are available at enterprise edition which not available at standard.

 

      Compression Indicates at least one table or index uses data compression

      Partitioning Indicates the database contains partitioned tables, indexes, schemes, or functions

      Transparent Data Encryption Indicates the database has been encrypted with transparent data encryption

      Change Capture Indicates the database has change data capture enabled

 

If one table is compressed in entire database then it is indicate

 

Output:

 

feature_name                   feature_id

Compression                     100

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: