Re: How to get around row size limitation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: moondaddy (moondaddy_at_nospam.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 03:11:17 -0600

Thanks this helps. 

-- 
moondaddy@nospam.com
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message 
news:u8qtF2dHFHA.1396@TK2MSFTNGP10.phx.gbl...
> 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)
  • 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
    ... it's really the only way to store> 8k of data in a single ... > 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)
  • Re: Cross platform password string encryption
    ... different microprocessors use different schemes for ... Languages: some languages are very specific about how they format and ... store various data types. ... format and store the same data type. ...
    (sci.crypt)