The following table specifies the maximum sizes and numbers for various objects defined in SQL Server 2005 databases or referenced in Transact-SQL statements. This data comes from Microsoft, so your mileage may vary because I don’t, for example, recommend storing 2GB XML files in a single row.
Table A-1. The Maximum Sizes and Numbers for Objects Defined in SQL Server 2005 Databases or Referenced in Transact-SQL Statements
Table A-2. Published Specifications for SQL Server Mobile Edition
Table A-3. ...