title: SQL Optimization: how many columns on a table?
body: <p>In a recent project I have seen a tables from 50 to 126 columns.</p>
  <p>Should a table hold less columns per table or is it better to separate them out into a new table and use relationships? What are the pros and cons?</p>