Select COUNT (1), $PARTITION. WORKDATEPFN (workdate) from Imgfile Group by $PARTITION. WORKDATEPFN (workdate) View the number of partition records select Workdate, $PARTITION. WORKDATEPFN (workdate) from Imgfile view record partition DBCC SHRINKFILE (N ' yxfile001 ', 1) Shrink partition file yxfile001 to 1M select * FROM Sysfiles query database files and log file information (filegroup, current file size, file maximum, file growth settings, file logical name, file path) Exec master.dbo.xp_fixeddrives Query the remaining space of each disk partition exec SP _spaceused querying disk usage of the current database select * from Sys.partition_range_values can query to the partition code
Focus on popular foreign websites
Facebook:http://www.fb-on.com
Facebook Official website: http://www.facebookzh.com
Facebook:http://www.cn-face-book.com
Youtube:http://www.youtubezh.com
Twitter:http://www.twitterzh.com
Server SQL statements view the number of partition records, view the partition where the records are located