Maximum no., of columns in Wide Table..?
Interview question and answer by:
Sakthi.Singaravel | Posted on: 4/6/2012 | Category:
SQL Server Interview questions | Views: 683 | |
Points: 40
Answer:
Answer:
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: http://msdn.microsoft.com/en-u |
Asked In: Sri Ram IT Services, Chennai
|
Alert Moderator
Found interesting? Add this to: