Some SQL Server Limitations:

The ultimate aim of this article is to describe the some limitations of Sql server table.

The following are some limitations of Sql server table.

The maximum number of columns per base table is 1024.

The maximum number of columns per index is 16.

The maximum number of columns per SELECT statement is 4096.

The maximum number of foreign key table references per table is 253.

The maximum number of parameters per stored procedure is 1024.

The maximum number of characters allowed for a table name is 128.

The maximum number of characters allowed for a column name 128.

The maximum number of columns in the view is 250.

A few maximum limitations for SQL Server 2005

Every now and then i see a question pop up that asks what is the max this or that in sql server?

Well here are some maximum values:

Bytes per short string column
8,000


Bytes per GROUP BY, ORDER BY
8,060


Columns in GROUP BY, ORDER BY
Limited only by number of bytes


Bytes per index key
900


Bytes per foreign key
900


Bytes per primary key
900


Bytes per row
8,060


Bytes per varchar(max), varbinary(max), xml, text, or image column
2^31-1


Characters per ntext or nvarchar(max) column
2^30-1


Clustered indexes per table
1


Columns per index key
16


Columns per foreign key
16


Columns per primary key
16


Columns per base table
1,024


Columns per SELECT statement
4,096


Columns per INSERT statement
1,024


Connections per client
32,767


Database size
1,048,516 terabytes


Databases per instance of SQL Server
32,767


Filegroups per database
32,767


Files per database
32,767


File size (data)
16 terabytes


File size (log)
2 terabytes


Foreign key table references per table
253


Identifier length (in characters)
128


Instances per computer
50 (Workgroup Edition only 16)


Locks per connection
Maximum locks per server


Locks per instance of SQL Server
Up to 2,147,483,647


Nested stored procedure levels
32


Nested subqueries
32


Nested trigger levels
32


Nonclustered indexes per table
249


Parameters per stored procedure
2,100


Parameters per user-defined function
2,100


REFERENCES per table
253


Rows per table
Limited by available storage


Tables per database
Limited by number of objects in a database


Partitions per partitioned table or index
1,000


Statistics on non-indexed columns
2,000


Tables per SELECT statement
256


Triggers per table
Limited by number of objects in a database


UNIQUE indexes or constraints per table
249 nonclustered and 1 clustered


User connections
32,767


XML indexes
249