Hi Steve from; http://msdn.microsoft.com/en-us/library/ms143432.aspx
Database size : 524,272 terabytes Databases per instance of SQL Server : 32,767 Bytes per varchar(max), varbinary(max), xml, text, or image column : 2^31-1 Bytes per row (*) : 8,060 (*) SQL Server supports row-overflow storage which enables variable length columns to be pushed off-row. Only a 24-byte root is stored in the main record for variable length columns pushed out of row; because of this, the effective row limit is higher than in previous releases of SQL Server. For more information, see the "Row-Overflow Data Exceeding 8 KB" topic in SQL Server Books Online. As always, please contact me if I can be of any futher assistance. Gavin "Beau" Baumanis Senior Application Developer PalCare Pty. Ltd. P: +61 -3 9380 3513 M: +61 -438 545 586 E: [email protected] W: http://palcare.com.au On 15/10/2010, at 3:36 PM, Steve Onnis wrote: > How much can this column actually hold? How would it translate to say a text > file in size? I am trying to work out if a heap of data should be able to fit > into the column or not > > > > > > > ======= > Email scanned by PC Tools - No viruses or spyware found. > (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16090) > http://www.pctools.com > ======= > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
