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 |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-05-12 : 10:20:01
|
| I have a table with 900 columns from T1……T900 (float datatype). As float takes 8 bytes so row size should be8 * 900 = 7200 bytes so each row is of 7200/1024 = 7.03125 kbEach 8 kb page should have 8060/7.03125 = 1146.311 rowsAnd if there are 68463 rows, then there should be 68463/1146.311 = 59.72462 pagesBut when I insert data into the table and run the dbcc showcontig command it shows there are 68463 pages scanned. It means there is one row per page. I want to know why is it so, and how can I overcome this problem. Because of this DB size is amazingly increasing. Please help me to solve this problem or correct me if I am wrong any where |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-12 : 10:22:23
|
| Yeah, chuck the design...CREATE TABLE myTable99(myKey99 char(10), myColNum int, myData99 float)Brett8-) |
 |
|
|
bridge
Yak Posting Veteran
93 Posts |
Posted - 2005-05-12 : 10:28:51
|
| Sorry I didn't understand |
|
|
|
|
|
|
DB size problem