DOMAINS function ... in MSSQL ??? SNOWFLAKEs and STAR schemas

DOMAINS function ... in MSSQL ??? SNOWFLAKEs and STAR schemas

 

  

Hi all,

Went into an interview session with a bunch of soldiers yesterday ... i
believe i handled the Oracle questions pretty well, the MS-SQL guru is
the one that's giving me a hard time 'coz he knows I prefer Larry from
Bill. Anyway, he mentioned something about DOMAINS function that he said
is not well know but is a feature/function that is very useful in
MS-SQL, most especially used when creating a table. I browse thru the
web and I can't find any article about it. Anyone out there who knows
what is it? Also can anyone give a short definition SNOWFLAKE and STAR
schemas used in OLAP ??? I'll search the web for more details but I just
want a concise definition first if they're 'interesting' at all or not
...

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous


DB2 & UDB email list listserv db2-l LazyDBA home page