Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-13 : 08:12:09
|
| Syed writes "How to estimate the amount of space required to store the data in a table?I am looking for a simple formula to calculate the size table. If the following information is already known number_of_rows, number_of_columns and datatypes.If I can find an example that will be great." |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-02-13 : 08:55:16
|
| Hmm... I know I saw the formulas in a book once, don't remember the title though. I'll let you know... |
 |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-02-13 : 10:02:23
|
| Maybe the following link will be useful:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-13 : 10:09:22
|
| Nice link Jay...added that one to my Favorites...Brett8-) |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
|
|
|
|
|
Estimating the size of a database 