How much data does SQL Server 2008 can handle?

What is the threshold of number o开发者_JS百科f registries and fields SQL Server can tolerate? In other words, how many rows and columns can be handled?

How much data (it's about size of data, not number of rows) it can handle depends on what edition. You can find details here: Maximum Capacity Specification for SQL Server.

When it comes to the number of rows, available storage should be the only limit.

See this MSDN article.

Short answer, however many can fit in the storage medium.

Until you run out of storage with up to 30k columns per table.

The average database is Mickey Mouse no matter how big you think it is...