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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to Calculate the Row Size

Author  Topic 

bridge
Yak Posting Veteran

93 Posts

Posted - 2005-05-11 : 05:36:40
If a table has two columns and two rows, columns are
ID int,
T1 float
and both the rows contain NULL values

what would be the size of each row?

Will row size would be the addition of its column's data type even if there is NULL, or row size will be calculated only if there is data in columns?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-11 : 16:22:59
Run sp_spaceused to see what the size of your table is.

Tara
Go to Top of Page
   

- Advertisement -