Can I use the same filegroup for multiple tables when partitioning a table? I partitioned a items table by year. It created five filegroups. Can I use the same file group for orders table or will I need to create separate filegroup?
Sql-server – Table partitioning filegroup
partitioningsql server
Related Question
- Sql-server – Improve performance by partitioning
- Sql-server – Partitioned Views – Storage of Indexes
- Sql-server – Dynamic Table partitioning on a daily basis
- Sql-server – How to remove the duplicate records from primary filegroup after partitioning
- Sql-server – SQL server – Re. Filegroup / partitioning
- Sql-server – Table Partitioning – database file increased after partitioning
Best Answer
Technically you can assign any existing/new filegroup to any new partition scheme (for other table).
However, you need to understand the existing partition function and scheme design, and more importantly the purpose of the existing partition. It could be partitioned for improved scalability and performance reason by having filegroup on different disks. Or it could be partitioned to archive older data on slower and cheaper disk. Or partitioned on a same/different disk for quicker subset access like during data loading process. So, the idea is to find out if the purpose of the new table partition inline with existing partition to determine if existing or new filegroup should be used.