Monday, January 11, 2010

[So I can find it in the future] SQL Server to the Max - “Maximum Capacity Specifications for SQL Server”

Notes from SQL Server Premier Field Engineer - Maximum sizes and numbers for SQL Server

“While working with SQL Server you've probably heard certain restrictions like 'There can be at most 1,024 columns declared in the table' or 'There can be only 8,600 bytes per row'. Some are urban legends and travel by the word of mouth others are hard to keep in the head even for people who constantly work with SQL Server. In case you wondered what these limits are, Microsoft has a complete list of them here . …”

Microsoft TechNet - Maximum Capacity Specifications for SQL Server

“The following tables specify the maximum sizes and numbers of various objects defined in SQL Server components.

image

…”

Every so often I need to look up something in the list and can never seem to craft my search right. Capturing this so I can easily find it in the future… ;)

No comments: