Some SQL Server Limitations
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
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 |