Spliting Data into file groups VS Partioning

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  June 16, 2009 at 1:36 pm

  #206028

  Guys,

  I have a 60 million row table which I split into a file group that has 4 files. This has improved the performance drastically, I also went a step

  further and split the clustered index into file group with 4 files. One question that still lingers how is splitting data into file groups different than

  partitioning using partition functions. When the table's data is split into file groups how does the SQL engine decide which row goes into which file wihtin the file group.

  Any suggestions and inputs would help.

  Thanks

• manishankar_83

  Old Hand

  Points: 391

  More actions

  June 16, 2009 at 10:24 pm

  #1010627

  Hi,

  Is there a way to do this without implementing Table partitioning ?

  I am not sure how a table data is stored in multiple file groups without table partitioning

  Are you sure you do not have any table partitioning here ??

  Thanks,

  Mani