SQL Server 2005 Specifications

Here are some maximum sizes and numbers of objects in SQL Server 2005 databases or referenced in T-SQL statements.

There are two edition for SQL Server 2005 for 32-bit and 64-bit. I have show here this information regarding 32-bit version. but there are almost same.

• Bytes per short string column 8000.


• Bytes per GROUP BY or in ORDER BY 8060.


• Bytes per primary key, foreign key and index key is 900.


• Bytes in source text of a stored procedure Lesser of batch size or 250 MB.


• Clustered indexes per table 1.


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


• Columns per base table 1024.


• Columns per SELECT statement 4096.


• Columns per INSERT statement 1024.


• Database size 1048516 terabytes.


• Nested subqueries level 32.


• Nested trigger levels 32.


• No. of Parameters per stored procedure and in user-defined function is 2100 parameters.


• Rows per table all most unlimited (Limited by available storage).


• Tables per SELECT statement 256