CODEWITHSUNDEEP
sql-server-2008
edgarmtze
edgarmtze

Reputation: 25038

How much data does SQL Server 2008 can handle?

What is the threshold of number of registries and fields SQL Server can tolerate? In other words, how many rows and columns can be handled?

Upvotes: 0

Views: 5302

Answers (3)

gbn
gbn

Reputation: 432200

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...

Upvotes: 1

D.N.
D.N.

Reputation: 2170

See this MSDN article.

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

Upvotes: 3

Fredrik Mörk
Fredrik Mörk

Reputation: 158309

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.

Upvotes: 3

Related Questions