title: How do you create a wide table in SQL Server 2008? and what are its limitations on use?
body: <p>I was reading the <a href="http://msdn.microsoft.com/en-us/library/ms143432.aspx" rel="noreferrer">Maximum Capacity Specifications for SQL Server</a> and I came across the designation of a wide table. It's different from a standard table in that is can have as many as 30,000 columns as opposed to a normal (narrow) table that is limited to the more familiar 1024 columns. I googled for wide table, but nothing seem to come up relevant. Does this new table type have a more formal name???</p>
  
  <p>So why do we have two different types of tables, how do you create this special table and what are the limitations of using this table that can seemingly hold more data ? anhyone know ?</p>