title: Does MS SQL server support table partitioning by List?
body: <p>I am pretty new to table partitioning technique supported by MS SQL server. I have a huge table that has more than 40 millions of records and want to apply table partitioning to this table. Most of the examples I find about the partition function is to define the partition function as Range LEFT|RIGHT for Values(......), but what I need exactly is to something like following example I found from Oracle web page:</p>
  
  <pre><code>CREATE TABLE q1_sales_by_region
        (..., 
         ...,
         ...,
         state varchar2(2))
     PARTITION BY LIST (state)
        (PARTITION q1_northwest VALUES ('OR', 'WA'),
         PARTITION q1_southwest VALUES ('AZ', 'UT', 'NM'),
         PARTITION q1_northeast VALUES  ('NY', 'VM', 'NJ'),
         PARTITION q1_southeast VALUES ('FL', 'GA'),
         PARTITION q1_northcentral VALUES ('SD', 'WI'),
         PARTITION q1_southcentral VALUES ('OK', 'TX'));     
   ); 
  </code></pre>
  
  <p>The example shows that we can specify a PARTITION BY LIST clause in the CREATE TABLE statement, and the PARTITION clauses specify lists of discrete values that qualify rows to be included in the partition. </p>
  
  <p>My question is does MS SQL server support table partitioning by List as well?</p>