Maximum no., of columns in Wide Table..?

 Posted by Sakthi.Singaravel on 4/6/2012 | Category: Sql Server Interview questions | Views: 1663 | Points: 40


Wide tables can define up to 30,000 columns. This increases the cost to maintain indexes on the table. Nonclustered indexes that are defined should be filtered indexes that are applied to data subsets.

Source: | Asked In: Sri Ram IT Services, Chennai | Alert Moderator 

Comments or Responses

Posted by: Hariinakoti on: 4/7/2012 | Points: 10
what is wide table? what is the use of wide table?
Posted by: Sakthi.Singaravel on: 4/8/2012 | Points: 10
A wide table is a table with a column set.
-Wide tables can define up to 30,000 columns .
-Applications can dynamically add and remove columns from wide tables.
-When data is added and removed from a wide table, performance can be affected .

Login to post response

More Interview Questions by Sakthi.Singaravel