Friday, 19 August 2011

Non Clustered indexes per tabel

Posted by Sanjeet Kumar Satpathy at 21:32 Labels:

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

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)