December 13, 2012 at 10:23 pm
I have a small doubt about image......
In sql server image datatype size has give 2gb or 2,147,483,647 bytes.
But sql server is not storing image in database it is out side of database only address of image will store in database......
there is a pointer and it will point to that image and fatch the image.
then why sql server has given 2,147,483,647 bytes only for storing the address???
if u want ui can reply me rajeshjaiswalraj@gmail.com
December 14, 2012 at 12:26 am
SQL Server supports up to 2,147,483,647 bytes for image data.
It doesn't use 2,147,483,647 bytes for the pointer.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 14, 2012 at 12:59 am
Hi,
If SQL Server supports up to 2,147,483,647 bytes for image data.
It doesn't use 2,147,483,647 bytes for the pointer.
Then only for storing address why they have located 2gb of space.
only storing the address max in mb or byte is more than enough.
December 14, 2012 at 3:13 am
Are you sure the data is stored outside of SQL Server? This is the case with FileStream for varbinary(max), but I'm not sure it is for the image datatype.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 14, 2012 at 3:23 am
Image stores the 16 byte pointer data in-row, the actual image data is farmed off to the the large object tree and the pointer details which pages make up the image data, so a 2GB file would consume 2GB of database space as it is stored in the database.
Also as you posted in 2008 forum, I am going to go out on a limb and say get upgrading your columns to the new large data types varchar(MAX), nvarchar(MAX), varbinary(MAX) as test, ntext and image are all depreciated data types and will be removed from a later version of SQL.
http://msdn.microsoft.com/en-us/library/ms189574%28v=sql.100%29.aspx
Usually, text, ntext, or image strings are large, a maximum of 2GB, character or binary strings stored outside a data row. The data row contains only a 16-byte text pointer that points to the root node of a tree built of internal pointers that map the pages in which the string fragments are stored.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply