Re: How to get around row size limitation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 16:36:10 -0500

Typical ways to get around row size limitation:

- store larger chunks in TEXT columns (which do not count toward row-size,
since they are stored off-row)
- separate related table

The major downfall with TEXT is that it doesn't work well with string
functions, can be cumbersome for searching (you can offset this by using
Full-Text Search), and cannot be used in local variables.

Other than that, it's really the only way to store > 8k of data in a single
column inside the database... 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"moondaddy" <moondaddy@nospam.com> wrote in message
news:uvdQWtdHFHA.2276@TK2MSFTNGP15.phx.gbl...
> I have a table which has a number of large notes columns where users
> sometimes need to record several pages of notes for each column.  So if I
> have 2 columns each varchar(4000) then at times the row size will exceed
its
> 8k limit and nasty problems will occur.  How is it that people are able to
> collect large blobs of data (I hardly consider this a blob, but it is
bigger
> than 8k)?  Do I need to use the nvarchar or text data type and if so, how
> does this get around the row size limit?  I'm hoping I don't have to use
the
> text data type as its been a long time since I used it, but as I recall,
it
> wasn't so user friendly to work with complex TSQL.
>
> Thanks for any input you can provide.
>
> -- 
> moondaddy@nospam.com
>
>

Relevant Pages

  • How to get around row size limitation
    ... I have a table which has a number of large notes columns where users ... collect large blobs of data (I hardly consider this a blob, ... Do I need to use the nvarchar or text data type and if so, ... wasn't so user friendly to work with complex TSQL. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to overcome very slight calculation error.
    ... Dim MyNumber As Single ... you can't store, or nor use "real" numbers, as they are a approximates. ... solution in this case is to use decimal number, or a data type of currency. ...
    (microsoft.public.access.modulesdaovba)
  • Re: simulating in visual basic - very stupid beginners question
    ... the computer simulated time clock which is supposed to be 7:15 when it ... You can store any datetime in Date, by fetching from a system clock, ... Here is a quick tutorial of how to work with the Date data type in VB. ... point arithimetic may arise as the Date storage is a Double. ...
    (microsoft.public.vb.general.discussion)
  • Fwd: data type for ip addresses
    ... data type for ip addresses ... CHAR, though it isn't the biggest waste of space in this world. ... you could also decide to store it as four fields of SMALLINT. ... Please do not use this email for correspondence. ...
    (comp.databases.informix)
  • Re: How to get around row size limitation
    ... > - store larger chunks in TEXT columns (which do not count toward row-size, ... >> I have a table which has a number of large notes columns where users ... >> collect large blobs of data (I hardly consider this a blob, ... Do I need to use the nvarchar or text data type and if so, ...
    (microsoft.public.sqlserver.programming)