Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is this possible? I have never seen it before but recently came into running some servers where the application/service creates a new data file and new data filegroup every week. Beyond the absurdity of this design ( and the developer mandate that we keep two years of data on hand, or 104 data files and filegroups) was my question as to "Is this possible?". Many thanks for the education in advance!

share|improve this question
up vote 1 down vote accepted

Yes, it is called table partitioning. A single table is created over multiple different filegroups and a column within the table is used to figure out which partition the data for that row should be in.

share|improve this answer
I was aware that you could partition databases and files, I was unaware of specific table partitioning. Thank you! – Ddono25 Dec 16 '10 at 2:21
No problem. It was introduced in SQL Server 2005, and requires the Enterprise Edition or higher. – mrdenny Dec 16 '10 at 3:55

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.