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.
…”
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:
Post a Comment
NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...
ALL comments are moderated. I will review every comment before it will appear on the blog.
Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...
I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...
Please see my comment policy for more information if you are interested.
Thanks,
Greg
PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...