title: How can I move a table to another filegroup in MS SQL Server?
body: <p>I have <code>SQL Server 2008 Ent</code> and <code>OLTP database</code> with two big tables. How I can move these tables to another <code>filegroup</code> without service interrupting? Now, about 100-130 records inserted and 30-50 records updated each second in these tables. Each table have about 100M records and six <code>field</code>s (including one field <code>geography</code>).</p>
  
  <p>I am looking for a solution in Google, but all solutions contain </p>
  
  <blockquote>
    <p>create second table, insert rows from first table, drop first table,
    etc</p>
  </blockquote>
  
  <p>Can I use partitioning functions for solving this problem?</p>