In Sql Server 2008 32 Bit addition ,following are the limit for Non Cluster Index and Cluster Index
Clustered indexes per table: 1
None clustered per table: 999
Nested sub queries: 32
Nested trigger levels: 32
Parameters per stored procedure: 2100
Parameters per user-defined function: 210
Comments
Post a Comment