Base Of Difference | Wide | Nonwide |
No of Columns | Wide table can contain upto 30,000 columns | Non-wide table can contain only 1024 columns. |
Transactional or Merge | Wide tables will not work with transactional or merge replications. | Non-wide can work with transactional or merge replications. |
OLAP System | Wide tables are used in OLAP systems. | Narrow tables are used in OLTP system |
Type | We can considered wide table to be denormalized tables. | We can consider Nonwide tables to be normalized tables. |
Verison & reason | Wide tables concepts comes in SQL Server 2008 as a new feature | Non-wide comes into picture to overcome the limitation of 1024 columns in narrow tables.
|