Viral Pala: indexes in sql server

Showing posts with label indexes in sql server. Show all posts

Thursday, April 14, 2011

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

Reference:

http://msdn.microsoft.com/en-us/library/ms143432.aspx