title: How do we change the page size of SQL Server?
body: <p>Per <a href="http://msdn.microsoft.com/en-us/library/ms190969.aspx" rel="nofollow noreferrer">MSDN</a>,</p>
  
  <blockquote>
    <p>In SQL Server, the page size is 8 KB. This means SQL Server databases
    have 128 pages per megabyte.</p>
  </blockquote>
  
  <p><strong>How do we change the page size, e.g. to 4 KB or 12 KB etc?</strong></p>
  
  <p>Also, is it due to an "<em>innate</em> hardware restriction" that page sizes are chosen to be 8 KB?</p>
  
  <p>Or is 8 KB simply an arbitrary good-enough number chosen based on heuristics for optimization of <em>majority</em> use cases?</p>