Home Forums SQL Server 2008 SQL Server 2008 Administration Maintaining Statistics RE: Maintaining Statistics
SQL Show
SSCertifiable
Points: 6143
More actions
April 25, 2013 at 7:24 am
#1609931
SELECT
p.[object_id],
p.[index_id],
pc.[partition_column_id],
pc.[modified_count]
FROM sys.system_internals_partition_columns pc
JOIN sys.partitions p
ON pc.[partition_id] = p.[partition_id]
WHERE p.[object_id] = OBJECT_ID ('Yourtablename');