Re: Image value column question
anonymous_at_discussions.microsoft.com
Date: 09/14/04
- Next message: Adam Machanic: "Re: Trim characters from start of string"
- Previous message: SqlJunkies User: "What would be a good approach to compare 2 SQL database structures?"
- In reply to: Andrew J. Kelly: "Re: Image value column question"
- Next in thread: Andrew J. Kelly: "Re: Image value column question"
- Reply: Andrew J. Kelly: "Re: Image value column question"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Sep 2004 07:22:01 -0700
Is it possible to store the image files outside the
database - separate disk or CD - and as that disk or CD
increase in size, the databse size is not increased? The
database will have a pointer to the location of the image.
>-----Original Message-----
>What I meant was that you don't have a choice where or
how it stores the
>image other than the text in row feature. The size of
the database always
>includes all the data in that database regardless of
where it is physically
>stored within the db. The size may not be the same if
you compare it before
>and after the move of the image files. Chances are it
will take up a little
>more space as a normal image vs. the text in row. But
you can store up to
>2GB per row.
>
>--
>Andrew J. Kelly SQL MVP
>
>
>"canaries" <anonymous@discussions.microsoft.com> wrote in
message
>news:1d2901c49a58$302d6f20$a501280a@phx.gbl...
>> The reason that I care where it puts the image is
because
>> of the space being taken up.
>>
>> Here is a better question. No matter where the image is
>> placed, the calculation of the database size is still
>> calculated with the image? Whether the text in row is
ON
>> or OFF, the size of the database will be the same?
>>
>>
>> >-----Original Message-----
>> >Yes it sets up the pointer for you. Since it moves the
>> image it has to keep
>> >track of where it put it. Why do you care where it put
>> the image? You
>> >access it thru the pointer not directly.
>> >
>> >--
>> >Andrew J. Kelly SQL MVP
>> >
>> >
>> >"canaries" <anonymous@discussions.microsoft.com> wrote
in
>> message
>> >news:188401c499d2$4debafd0$a401280a@phx.gbl...
>> >> In turning off the the text in row option, does it
setup
>> >> the pointer automatically? How can I check to see
where
>> >> the location of the image will be?
>> >>
>> >>
>> >> >-----Original Message-----
>> >> >From BooksOnLine:
>> >> >
>> >> >Turning off the text in row option can be a long-
>> running,
>> >> logged operation.
>> >> >The table is locked and all in-row text, ntext, and
>> image
>> >> strings are
>> >> >converted to regular text, ntext, and image strings.
>> The
>> >> length of time the
>> >> >command must run and the amount of data modified
>> depends
>> >> on how many text,
>> >> >ntext, and image strings must be converted from in-
row
>> >> strings to regular
>> >> >strings.
>> >> >
>> >> >--
>> >> >Andrew J. Kelly SQL MVP
>> >> >
>> >> >
>> >> >"canaries" <anonymous@discussions.microsoft.com>
wrote
>> in
>> >> message
>> >> >news:007101c499bc$8f82c570$a601280a@phx.gbl...
>> >> >> I have a table that has a column defined
as 'image'
>> with
>> >> >> the text in row option set to ON where the value
is
>> in
>> >> the
>> >> >> data row.
>> >> >>
>> >> >> The table is growing to fast, and I want to change
>> the
>> >> >> text in row option to OFF to allow a pointer in
the
>> data
>> >> >> row instead of the value.
>> >> >>
>> >> >> What is the process for converting the current
data
>> in
>> >> >> this table once I change the text in row option to
>> OFF?
>> >> >>
>> >> >> Thanks in advance.
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Adam Machanic: "Re: Trim characters from start of string"
- Previous message: SqlJunkies User: "What would be a good approach to compare 2 SQL database structures?"
- In reply to: Andrew J. Kelly: "Re: Image value column question"
- Next in thread: Andrew J. Kelly: "Re: Image value column question"
- Reply: Andrew J. Kelly: "Re: Image value column question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
