SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2007

Finding the relationship of a filegroup and a partition

The other day, I was trying to find out which partition is on which filegroup for a a partitioned table. I can get it by script out the partition scheme and look at the defintition to figure out. But I want to have a query to do this for me…

Read more

1 comments, 1,530 reads

Posted in DBA Philosophy on 12 December 2007