You can speed up text columns in MS SQL also :) MS SQL Server supports a
feature which stores a specific amount of characters in the text column,
and the rest is stored in pointers. This can result in a dramatic
improved performance, but this depends on the amount of text you have.
When you look a
Only 16 bytes are stored in the DB. It's a pointer to a file. :-)
--Ben
DRE wrote:
> Dooh! I was mislead by the number next to text in the table design
> area. I thought that was the max size, it only shows 16!
>
> Thanks
>
> DRE
>
>
> On Thu, 11 Nov 2004 15:06:08 -0500, Ben Doom <[EMAIL PR
I got around
the issues. I haven't tried it lately, however, so I don't remember why
I did it, but it worked quite well.
MAD
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 11, 2004 2:06 PM
To: CF-Talk
Subject: Re: OT sql2k question
Text
Dooh! I was mislead by the number next to text in the table design
area. I thought that was the max size, it only shows 16!
Thanks
DRE
On Thu, 11 Nov 2004 15:06:08 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> Text fields are only limited by the OS's maximum file size. Gigs and gigs.
>
> You'r
Text fields are only limited by the OS's maximum file size. Gigs and gigs.
You're thinking of the varchar limit. There's not way to go past the
limit on varchars, but you can always use text instead.
I hope that made sense.
--Ben
DRE wrote:
> Hi,
> I've noted that the text fields in sql 200
Yes varchar can only be 8000 max you can use the text datatype
-Original Message-
From: DRE [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 11, 2004 12:03 PM
To: CF-Talk
Subject: OT sql2k question
Hi,
I've noted that the text fields in sql 2000 only go out to 8000 chars.
Is th
Hi,
I've noted that the text fields in sql 2000 only go out to 8000 chars.
Is there a means to increase this?
A good resource for these questions would be great as well.
Thanks.
--
DRE
www.webmachineinc.com
www.theanticool.com
~
7 matches
Mail list logo
