Maximum Capacity Specifications for SQL Server


One day, one of my team member asked me about what is maximum no of column that one table can have?

so when i got time i have done some googling on that & find some useful information that i am sharing with you all.

Here is some useful Maximum size limits for SQL Server 2005. Hope this will help you !!!

Database Engine object

Max Size

Columns per nonwide table

1024

Columns per wide table

30,000

Columns per SELECT statement

4,096

Columns per INSERT statement

4,096

Columns per foreign key

16

Columns per primary key

16

Bytes per foreign key

900

Bytes per primary key

900

Bytes per row

8,060

Foreign key table references per table

253

Bytes per GROUP BY, ORDER BY

8,060

Clustered indexes per table

1

Columns in GROUP BY, ORDER BY

Limited only by number of bytes

Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement

10

Length of a string containing SQL statements (batch size)

65,536 * Network packet size

Nested stored procedure levels

32

Nested subqueries

32

Nested trigger levels

32

Nonclustered indexes per table

999

Parameters per stored procedure

21,00

Parameters per user-defined function

21,00

REFERENCES per table

253

Tables per SELECT statement

Limited only by available resources

Columns per UPDATE statement (Wide Tables)

4096

 

Reference link : Click here

Jai Ganesh

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s