Posted by Erland Sommarskog on 07/25/05 16:28

Zero.NULL (manish19@gmail.com) writes:
> can you please guide me where can I get the white papers on SQL Server
> capabilities (i.e. storage capacity of table)

I will have to admit that I can't point directly to any such white
paper, but you may find something useful at
http://www.microsoft.com/technet/prodtechnol/sql/default.mspx.

But as a general guidance, recall that SQL Server is designed to be
an enterprise solution. There are SQL Server databases out there with
over 10 TB of data. It goes without saying that an engine that is
capable to handle that amount of data, should not have any problem with
a couple of million rows.

That is, and this can not be stressed enough, proivided that you have
proper indexing.

I should also add that the number of rows is not really the crucial
part, but more the size in megabytes. If you have ten million rows, ir
makes quite a difference if your average row size is ten bytes or
7500 bytes.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]