In sql server 2005
Clustered Index 1 + Non clustered index 249 = 250 index
In sql server 2008/2008 R2/2012
Clustered Index 1 + Non clustered index 999 = 1000 index
Reference: http://msdn.microsoft.com/en-us/library/ms143432(v=sql.110).aspx
Clustered Index 1 + Non clustered index 249 = 250 index
In sql server 2008/2008 R2/2012
Clustered Index 1 + Non clustered index 999 = 1000 index
Reference: http://msdn.microsoft.com/en-us/library/ms143432(v=sql.110).aspx