SQLSVR2009? You Mean 2010 right? Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA
Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: [email protected] WWW: http://www.coldgen.com/ ABN: 80 826 226 128 On Fri, Oct 15, 2010 at 15:54, Gavin Beau Baumanis <[email protected]>wrote: > 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<http://www.pctools.com/?cclick=EmailFooterClean_51> > ======= > > -- > 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]<cfaussie%[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.
