SQL Server Performance Forum – Threads Archive

SQL Blob

Hi, This is Zeeshan Ahmed from itHighway Technology.
I want to know what is SQL Blob? Is it something to do with images security?
Any Idea…
Any Help….. Will be greatly appriciated,
Thanks
Zeeshan Ahmed

You can use BLOBs to perform database operations that require you to work with large segments of data at a time. SQL Server 2000 and 7.0 store BLOB data on a different data page than the rest of the row’s data. SQL Server stores the BLOB data as a collection of 8KB pages that it organizes in a B-tree structure. Each row’s BLOB column contains a 16-byte pointer to the root B-tree structure that tracks the various blocks of data that make up the BLOB. If the amount of binary data is less than 64 bytes, SQL Server stores it as part of the root structure itself. (in future kindly post the questions in relevant forums) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

This explains it all:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx ———————–
–Frank
http://www.insidesql.de
———————–

Locked as per Frank’s comments and follow as adivsed. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>