Also don't use text use varchar(max) as SQL Server is depreciating text.
http://technet.microsoft.com/en-us/library/ms189087.aspx
Paul
On 15/10/2010 5:31 PM, Peter Tilbrook wrote:
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: pe...@coldgen.com <mailto:pe...@coldgen.com>
WWW: http://www.coldgen.com/
ABN: 80 826 226 128
On Fri, Oct 15, 2010 at 15:54, Gavin Beau Baumanis
<b...@palcare.com.au <mailto:b...@palcare.com.au>> 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: b...@palcare.com.au <mailto:b...@palcare.com.au>
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 cfaussie@googlegroups.com
<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com
<mailto:cfaussie+unsubscr...@googlegroups.com>.
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 cfaussie@googlegroups.com
<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com
<mailto:cfaussie%2bunsubscr...@googlegroups.com>.
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 cfaus...@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com.
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 cfaus...@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en.