SQL Database and Table memory size

hai all.
This post explaining is


How many rows add for one table in sql server 2008 r2 ?

and

can we how many database access in sql server 2008 r2?

and

how many coloumns add for one row in table on sql server 2008 r2?

and

what is size level  in sql server 2008 r2?



These are some of the Maximum Capacity Specifications for SQL Server 2008 R2

Database size: 524,272 terabytes
Databases per instance of SQL Server: 32,767
Filegroups per database: 32,767
Files per database: 32,767
File size (data): 16 terabytes
File size (log): 2 terabytes
Rows per table: Limited by available storage

Tables per database: Limited by number of objects in a database


The DataBase capacity is limited by the amount of storage it has. If you have 100 Gigabytes of storage available, then the database size will be under that. If you have 100 Terabytes of storage, than that will be the limit to the size of the database. Enterprise database systems like Oracle, MySQL, and SQL Server are more limited by the available storage than anything else.

 It is far more complex because there are certain amounts for various sizes based on how you design the database. The documents also clearly show that things like the number of columns per table is 1,024 for a normal table, or 30,000 for a wide table. SQL Server doesn't have a limit on rows, except the fact that you can't add more rows when you run out of storage.

Bottom line, if you're worried about the capacity chances are you won't hit it since the database can support almost half a petabyte in size.