How are LOB columns handeled in sqlserver

Hi ,
I am new to sqlserver family.
when doing the database design , i have the following question.
let's say we have emp table which have empid,empname,deptno,
as well as empPicture, empGreeting, empFamilyPict.
Should we store all the lob columns(empPicture, empGreeting, empFamilyPict)
in a seperate table . what is the best practice for sqlserver 2000 & 2005.
The oracle DB takes care of LOB if it is > 4000 bytes
(ie)when you use clobs, they are moved out of the table into their own
segment when they exceed 4000 bytes, the work is done for you, no need to
factor them out
special.
similarly for Bfiles which is always external.
How does Sqlserver 2000 & 2005 handle this . Both handle LOB's in similar
fashion?
thanks in adv
ThirumaranHi
http://www.aspfaq.com/show.asp?id=2149
"thirumaran" <thirumaran@.discussions.microsoft.com> wrote in message
news:530AF331-165C-411D-915D-22D37A78EDC0@.microsoft.com...
> Hi ,
> I am new to sqlserver family.
> when doing the database design , i have the following question.
> let's say we have emp table which have empid,empname,deptno,
> as well as empPicture, empGreeting, empFamilyPict.
> Should we store all the lob columns(empPicture, empGreeting,
> empFamilyPict)
> in a seperate table . what is the best practice for sqlserver 2000 & 2005.
> The oracle DB takes care of LOB if it is > 4000 bytes
> (ie)when you use clobs, they are moved out of the table into their own
> segment when they exceed 4000 bytes, the work is done for you, no need to
> factor them out
> special.
> similarly for Bfiles which is always external.
> How does Sqlserver 2000 & 2005 handle this . Both handle LOB's in similar
> fashion?
> thanks in adv
> Thirumaran
>
>
>
>|||In addition to Uri's answer you may want to check out LOB in BooksOnLine
2005. This part answers part of you question for 2005.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/813586f1-edfe-471e-9338-e55e689a1aaa.htm
Andrew J. Kelly SQL MVP
"thirumaran" <thirumaran@.discussions.microsoft.com> wrote in message
news:530AF331-165C-411D-915D-22D37A78EDC0@.microsoft.com...
> Hi ,
> I am new to sqlserver family.
> when doing the database design , i have the following question.
> let's say we have emp table which have empid,empname,deptno,
> as well as empPicture, empGreeting, empFamilyPict.
> Should we store all the lob columns(empPicture, empGreeting,
> empFamilyPict)
> in a seperate table . what is the best practice for sqlserver 2000 & 2005.
> The oracle DB takes care of LOB if it is > 4000 bytes
> (ie)when you use clobs, they are moved out of the table into their own
> segment when they exceed 4000 bytes, the work is done for you, no need to
> factor them out
> special.
> similarly for Bfiles which is always external.
> How does Sqlserver 2000 & 2005 handle this . Both handle LOB's in similar
> fashion?
> thanks in adv
> Thirumaran
>
>
>
>