Lately I have been struggling on a specific server in an environment I have been working on. Due to the need for partitioning in the cube, the project demanded an Enterprise Edition of SQL Server 2008R2. The only installation available, with Ent. Ed., had some 80+ databases, and several cubes, installed and running.
As I browsed through the databases, I noticed that quite a few of them could be run on a Standard Edition. I then turned to create a T-SQL statement, that would show which Ent. Ed. features was in use, in each database.
EXEC sp_MSforeachdb N'SELECT * FROM sys.dm_db_persisted_sku_features' GO
Turns out, none, zero, zip, nada of the databases uses any Ent. Ed. features. Imagine that.
- Further reading: