Get a List of Tables That Are Compressed
By SQLRx Admin | Beginner , Helpful Scripts , SQL Administration , SQL Server , Tip of the Month
Find out if any of your tables are compressed in your database using the query below. Compressed tables can save space and make queries run faster. — Compressed Tables select distinct t.name AS CompressedTables from sys.partitions p inner join sys.tables t on p.object_id = t.object_id where p.data_compression > 0 If you don’t have any tables […]
Continue reading