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 |
|
jpiscit1
Posting Yak Master
130 Posts |
 Posted - 2005-03-01 : 10:10:58
|
| Is there a simple way (other than using a calculator) to determine row storage size? I know a row cannot exceed 8060 bytes. But of that 8060 allowed bytes, how much have I actually used?For example, if I had three columns Number1, number2 and number3, all int @ 4 bytes each, my row allows for 12 bytes of data. I used sp_spaceused on the employees table in Northwind which returns reserved KB (in this case 320 KB). It also returns number of rows (in this case 9). Would this be a simple case of 320/9 = 35.55KB per row??Thoughts?Your limits are only as far as you set your boundries.... |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-02 : 15:14:10
|
| Have a look for "estimating table size" in BoLKristen |
 |
|
|
|
|
|
How to Calc row size allocated