Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bmsgharr
Starting Member
5 Posts |
 Posted - 2004-10-15 : 08:49:34
|
| Is the image datatype stored inline, or not?TIAGrahm Harris |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-15 : 10:30:47
|
emmm.... what do you mean by inline?Go with the flow & have fun! Else fight the flow  |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-10-15 : 10:34:07
|
I think it's stored like the text-datatype...not sure how that is but it's definetly not like the other datatypes  I have read somewhere that only a pointer is stored in the datapage and that the actual data is somewhere else.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
bmsgharr
Starting Member
5 Posts |
Posted - 2004-10-15 : 10:58:20
|
| OK. Is the column stored in the data file at the same position as the other fields or is the Image field stored in another file seperate to its identity coloumn |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-16 : 01:46:51
|
| My understanding is that the first page full is, yes. Then the rest of it is parcelled up and stored wherever. So if you images are small, and there is not much other data in the row ... then maybe!Kristen |
|
|
|
bmsgharr
Starting Member
5 Posts |
Posted - 2004-10-16 : 08:02:07
|
| Thanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-16 : 08:22:22
|
| Image and text data are stored separately from regular data. As lumbago stated, the data page contains only a pointer to the pages that contain the actual text/image. This data can be stored in the same filegroup as the regular data, or you can specify a different filegroup with TEXTIMAGE_ON clause of the CREATE TABLE statement. Text/image is stored on 8K data pages, but pages are not shared by multiple rows (i.e. 3 rows with text/image will use at least 3 data pages to store them) Lastly, you can set an option for text in row, which will store up to 7000 bytes (or whatever you set it for) of text data to be stored on the actual data page. Any values larger than that limit are stored normally (pointer to separate page) Books Online has more detail under "CREATE TABLE" and "sp_table_option". |
|
|
|
|
|
|
Image data type