Wednesday, August 1, 2012

What is the maximum number of Index per table in MS SQL Server?

For SQL Server 2005:
 1 Clustered Index + 249 Nonclustered Index = 250 Index
For SQL Server 2008:
 1 Clustered Index + 999 Nonclustered Index = 1000 Index

No comments :