View the number of records in a file group in a partition table

1. First, find the partition number corresponding to the file group

[SQL]View plaincopy

1. Use [dB]
2. Go
4. -- File group to be split
5. Select FG. Name
6. , Sp. destination_id
7. From SYS. destination_data_spaces sp
8. Inner join SYS. partition_schemes SCM on sp. partition_scheme_id = SCM. data_space_id
9. Inner join SYS. filegroups FG on FG. data_space_id = sp. data_space_id
10. Where SCM. Name = 'partition Scheme'
11. And FG. Name = 'file group logical name ';

2. Obtain the number of records based on the Partition Number

Select count (*) from [Partition Table] where $ partition. Partition Function (partition by column) = Partition Number