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 2005 Forums
 Transact-SQL (2005)
 How to calculate record size

Author  Topic 

imughal
Posting Yak Master

192 Posts

Posted - 2009-10-26 : 02:35:49
Hi,

how do i calculate axact record size. i have table with int and nvarchar data type.

thx

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-10-26 : 08:11:27
You could use DATALENGTH on each column, or see BOL for "Estimating the Size of a Table "

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page
   

- Advertisement -