title: What is the difference between Wide and Nonwide tables in SQL 2008?
body: <p>I was looking at this page on MSDN:</p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/ms143432.aspx" rel="noreferrer">Maximum Capacity Specifications for SQL Server 2008</a></p>
  
  <p>And it says the following:</p>
  
  <blockquote>
  Max Columns per 'nonwide' table: 1,024<br/>
  Max Columns per 'wide' table: 30,000
  </blockquote>
  
  <p>However I cannot find any information on the difference between 'wide' and 'nonwide' tables in SQL 2008. If I wanted to define a 'wide' table, how would I do it?</p>