File Groups

• David Todd-242471

  Right there with Babe

  Points: 797

  More actions

  December 10, 2009 at 7:21 pm

  #1090951

  Hi,

  I accept that others have tested and found that everything is created on FG1.

  >> from SQL 2008 BOL

  If CLUSTERED is specified or the constraint otherwise creates a clustered index, and a <partition_scheme> is specified that differs from the <partition_scheme> or filegroup of the table definition, or vice-versa, only the constraint definition will be honored, and the other will be ignored.

  <<

  I read that and figured that both would be created on FG2, that is, the filegroup specification on the clustered indexed is ignored.

  But looking at it again, it could be read either way ...

  Cheers

  David

• bhushanvinay

  SSCrazy

  Points: 2253

  More actions

  February 27, 2010 at 3:57 am

  #1126044

  Any DBCC PAGE output on this.

  Regards
  Vinay