Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 660 reads

Posted in DBA Philosophy on 12 December 2007