Filegroup Manipulations

I've got a few posts up here with different filegroup manipulations, but here is a very quick reference for adding/removing files and filegroups to your database:

  /* ADD FILEGROUPS */

  ALTER DATABASE DatabaseName

  ADD FILEGROUP FilegroupName

  GO

  /* ADD FILES  */

  ALTER DATABASE DatabaseName

  ADD FILE 

  ( NAME = Filename,

 FILENAME = 'C:\MSSQL\DATA\Filename.ndf',SIZE = 50, FILEGROWTH = 10%)

  TO FILEGROUP FilegroupName

  /* REMOVE FILES  */

  ALTER DATABASE DatabaseName

  REMOVE FILE Filename

  GO

  /*  REMOVE FILEGROUPS  */

  ALTER DATABASE DatabaseName

  REMOVE FILEGROUP FilegroupName

  GO 

A couple others...   

  Move large table to a new filegroup

  List the objects on your filegroups