Select from following answers:- 250 Indexes
- 1000 Indexes
- 1 clustered , 249 non clustered in 2005 and 1 clustered , 999 non clustered in 2008
- 1250 indexes
- All Above
For SQL Server 2005:
1 Clustered Index + 249 Nonclustered Index = 250 Index
For SQL Server 2008:
1 Clustered Index + 999 Nonclustered Index = 1000 Index
Show Correct Answer
Source: http://msdn.microsoft.com/en-u | Asked In: Many Interviews |
Alert Moderator