Tìm những table được partition trong SQL Server

 Tìm những table được partition trong SQL Server

SELECT partition_number,rows,object_name(object_id)
FROM sys.partitions s
WHERE EXISTS(SELECT NULL 
                FROM sys.partitions s2 
                WHERE s.object_id = s2.object_id 
                AND partition_number > 1
                AND s.index_id = s2.index_id)

where $Partition.yyyy_mm_yy(birtdhay)=$Partition.yyy.mmd..d('2014-05-05')

http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/listing-tables-that-are-truly/