how to know the FileGroup with NEXT USED flag set

• ahmed_b72

  Ten Centuries

  Points: 1251

  More actions

  September 11, 2011 at 10:57 pm

  #243019

  Hi,

  In my attempt to understand partitioning in SQL Server 2008, I successfully created a Partition Function, Partition Scheme and some testing partitioned table. The partiion function returns three ranges ahd the partition scheme maps the ranges to four filegroups with the last one flagged as "NEXT USED".

  My question is: how can I know the filegroups used in a partition scheme and which one hast its NEXT USED flag set?

  BTW, the table sys.partition_schemes doesn't do any good.

• ahmed_b72

  Ten Centuries

  Points: 1251

  More actions

  September 12, 2011 at 4:39 pm

  #1380360

  I found the answer in the following article:

  http://sqlfascination.com/2009/09/30/how-to-remember-the-next-used-filegroup-in-a-partition-scheme