Thank this author by sharing:
Download in .rgtool format for use with
SQL Scripts Manager, a free tool that provides simple GUIs for SQL scripts.
By Francesco Quaratino,
This script helps to know what kind of compression has been applied to all database objects. So, for every object, it shows:
This report is particularly useful in presence of a lot of tables in a database.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.