Re: How much space does the long character data type use.
From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 04/30/04
- Next message: Jacco Schalkwijk: "Re: Processes seen in enterprise manager"
- Previous message: Tim Bird: "Re: Nasty Test string SELECT Statement"
- In reply to: Emerson: "Re: How much space does the long character data type use."
- Next in thread: Emerson Dixon: "Re: How much space does the long character data type use."
- Reply: Emerson Dixon: "Re: How much space does the long character data type use."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Apr 2004 07:30:09 -0500
The max length for text data is 2GB and the reported size is the 'text in
row' size. With the default length of 16, only a pointer to the separate
text pages is stored in the data row. You can adjust the 'text in row size
to control how much text data is stored in the data row but the max length
is still 2GB.
See the SQL 2000 Books Online <cm_8_des_04_0x5t.htm> for details.
-- Hope this helps. Dan Guzman SQL Server MVP "Emerson" <edixon64@hotmail.com> wrote in message news:69c501c42ea8$31b315a0$a001280a@phx.gbl... > Hi Barry, > Thanks you for replying. > What is puzzling me is that when I run sp_help on the > table I see that the EMPLID field is CHAR with a length of > 11 which I can understand because you cannot enter more > than 11 characters in the EMPLID field. However the > COMMENT field is TEXT with a length of 16 but you can > enter much more than 16 characters. > > How is this possible and how does it affect the disk space > utilization? > > >-----Original Message----- > >There is a 16 byte overhead on the text, ntext, and image > data types. > > > >If your data in these columns is small, look at "Text in > Row Data" in BOL. > > > >---------- > > > >Barry McAuslin > > > >Look inside your SQL Server files with SQL File Explorer. > >Go to http://www.sqlfe.com for more information. > > > >"Emerson Dixon" <edixon64@hotmail.com> wrote in message > >news:075c01c42d44$45936490$7d02280a@phx.gbl... > >> We currently use PeopleSoft HRMS on MS SQL SERVER 2000. > >> One of the tables we use have a COMMENT field which is a > >> Long Character datatype. In SQL the data type show up > >> as 'Text'. How does this data type utilize disk space? > >> Would the size grow based on the number of characters > >> entered in the field or does the system reserve space as > >> it does with other data type. How much space does it > >> reserve when a field is the long character datatype. > >> > >> > > > > > >. > >
- Next message: Jacco Schalkwijk: "Re: Processes seen in enterprise manager"
- Previous message: Tim Bird: "Re: Nasty Test string SELECT Statement"
- In reply to: Emerson: "Re: How much space does the long character data type use."
- Next in thread: Emerson Dixon: "Re: How much space does the long character data type use."
- Reply: Emerson Dixon: "Re: How much space does the long character data type use."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
