Geek City: Where are LOBs stored?

Posted by Kalen Delaney on SQL Blog See other posts from SQL Blog or by Kalen Delaney
Published on Sun, 26 Jun 2011 21:27:00 GMT Indexed on 2011/06/27 0:28 UTC
Read the original article Hit count: 364

Filed under:

filegroups

|

LOBs

|

storage

When researching a question from one of the students in my class last week, I was reading the documentation for CREATE TABLE about storing LOB columns at http://msdn.microsoft.com/en-us/library/ms174979.aspx . For this discussion LOB columns includes text, image, ntext, xml and the MAX columns when they are over 8000 bytes and stored outside the regular data row. I knew that SQL Server gives us the capability of storing LOB columns in a separate filegroup with the TEXTIMAGE_ON clause, but I was surprised...(read more)

© SQL Blog or respective owner

Related posts about filegroups

SQL Server 2005 standard filegroups / files for performance on SAN

as seen on Server Fault - Search for 'Server Fault'
I submitted this to stack overflow (here) but realised it should really be on serverfault. so apologies for the incorrect and duplicate posting: Ok so I've just been on a SQL Server course and we discussed the usage scenarios of multiple filegroups and files when in use over local RAID and local… >>> More
SQL Server 2005 standard filegroups / files for performance on SAN

as seen on Server Fault - Search for 'Server Fault'
Ok so I've just been on a SQL Server course and we discussed the usage scenarios of multiple filegroups and files when in use over local RAID and local disks but we didn't touch SAN scenarios so my question is as follows; I currently have a 250 gig database running on SQL Server 2005 where some tables… >>> More
SQL Server 2005 standard filegroups / files for performance on SAN

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok so I've just been on a SQL Server course and we discussed the usage scenarios of multiple filegroups and files when in use over local RAID and local disks but we didn't touch SAN scenarios so my question is as follows; I currently have a 250 gig database running on SQL Server 2005 where some tables… >>> More
Restore Partioned database into multiple filegroups

as seen on Stack Overflow - Search for 'Stack Overflow'
does anyone have any query to restore partioned db that having multiple file groups,In the restore option in the SSME i need to edit manually all the path of the filegroups restore as option it little bit tedious as it having more than 150 filegroups eg:USE master GO -- First determine the number… >>> More
Geek City: Where are LOBs stored?

as seen on SQL Blog - Search for 'SQL Blog'
When researching a question from one of the students in my class last week, I was reading the documentation for CREATE TABLE about storing LOB columns at http://msdn.microsoft.com/en-us/library/ms174979.aspx . For this discussion LOB columns includes text, image, ntext, xml and the MAX columns when… >>> More

Related posts about LOBs

I see no LOBs!

as seen on SQL Blog - Search for 'SQL Blog'
Is it possible to see LOB (large object) logical reads from STATISTICS IO output on a table with no LOB columns? I was asked this question today by someone who had spent a good fraction of their afternoon trying to work out why this was occurring – even going so far as to re-run DBCC CHECKDB to see… >>> More
Geek City: Where are LOBs stored?

as seen on SQL Blog - Search for 'SQL Blog'
When researching a question from one of the students in my class last week, I was reading the documentation for CREATE TABLE about storing LOB columns at http://msdn.microsoft.com/en-us/library/ms174979.aspx . For this discussion LOB columns includes text, image, ntext, xml and the MAX columns when… >>> More
External table and preprocessor for loading LOBs

as seen on Oracle Blogs - Search for 'Oracle Blogs'
I was using the COLUMN TRANSFORMS syntax to load LOBs into Oracle using the Oracle external which is a handy way of doing several stuff - from loading LOBs from the filesystem to having constants as fields. In OWB you can use unbound external tables to define an external table using your own arbitrary… >>> More
Windows Azure Recipe: Enterprise LOBs

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Enterprises are more and more dependent on their specialized internal Line of Business (LOB) applications than ever before. Naturally, the more software they leverage on-premises, the more infrastructure they need manage. It’s frequently the case that our customers simply can’t scale up their hardware… >>> More
How to reclaim storage for deleted LOBs

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a LOB tablespace. Currently holding 9GB out of 12GB available. And, as far as I can tell, deleting records doesn't reclaim any storage in the tablespace. I'm getting worried about handling further processing. This is Oracle 11.1 and the data are in a CLOB and a BLOB column in the same table… >>> More