Free for PREMIUM members
[Webinar] Streamline your web hosting managementRegister Today
Select Table_name as "Table name"
Where Table_type = 'BASE TABLE' and Objectproperty
(Object_id(Table_name), 'IsMsShipped') = 0
Open in new window
FROM sys.tables t
INNER JOIN sys.partitions p ON t.object_id = p.object_id
WHERE p.data_compression IN (1, 2)
The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!