SQL Server and Numbers

Few informations about maximum limits & sizes in SQL Server.

Though practically we might not be crossing these maximum limits & sizes in SQL Server in most cases ,it is always better to be aware of it.

page size  (128 pages/MB)	8 KB
Extents (16 extents/MB)	64 KB
Databases per instance of SQL Server	32,767
Files per database	32,767
User connections	32,767
Common table expression MAX recurrsion count	32,767
DB_ID of resource database	32,767
Columns per primary key	16
Columns per foreign key	16
Columns per SELECT statement	4,096
Columns per INSERT statement	4,096
Columns per UPDATE statement	4,096
Nested stored procedure levels	32
Nested subqueries	32
Nested trigger levels	32
Parameters per user-defined function	2100
Parameters per stored procedure	2100
Clustered indexes per table	1
Non Clustered indexes per table	In SQL Server 2005 = 249,In SQL Server 2008 = 999
Max number of included columns in covering index	1023

 

For more information , refer below link :

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

• http://technet.microsoft.com/en-us/library/ms189631.aspx