title: SQL server partitioning
body: <p>I have a table that has millions of records and we are looking at implementing table partitioning. Looking at it we have a foreign key "GroupID" that we would like to partition on. Is this possible? </p>
  
  <p>The Group will have more entries added to it, so as new GroupID's are added can the partition's be made dynamically?</p>