title: Sql server table partitioning - can I distribute tables across servers?
body: <p>I have read many sites, guides, etc; also note I cannot test what I am asking as do not have two computers. </p>
  
  <p>Table partitioning simply means that the table is logically divided, such that a particular range is handled by a particular partition only there by reducing load and also allowing parallelism.</p>
  
  <p>there is a mention of partitions being on different hard disks but there is never any mention of partitions being on different computers.</p>
  
  <p>Is that possible?</p>
  
  <p>So for example, data with id&lt;50000 will be stored on one computer and the remainder will be stored on the other?</p>