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
 SQL Server Administration (2005)
 nvarchar(max)

Author  Topic 

rjgamer
Starting Member

8 Posts

Posted - 2007-12-11 : 16:35:44
Does anyone know the formula to calcuate the space occupied by an nvarchar(max) column for the purposes of sizing a table?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-11 : 16:42:32
16 bytes.
Only a pointer to the real data is stored in the table.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -