Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ozSQLServer
Starting Member
32 Posts |
 Posted - 2011-09-12 : 00:57:15
|
| 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.Cheers,ozSQL |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-12 : 10:01:09
|
| http://sqlfascination.com/2009/09/30/how-to-remember-the-next-used-filegroup-in-a-partition-scheme/ |
 |
|
|
ozSQLServer
Starting Member
32 Posts |
Posted - 2011-09-12 : 18:40:49
|
| Thanks for the very helpful article.Cheers,ozSQL |
|
|
|
|
|
|
how to know the FileGroup with NEXT USED flag set