Federated database VS single database server

Is there any expert in designing federated database ? I need a reference in designing a federated database. Also a comparison - Federated database VS single database server. I need a information in decided what solution i should go for.
Best regards,
TawanaCheck out the Microsoft Patterns and Practices web site. There is a white
paper there on designing federated databases along with best practices and
comparisons.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"tawana" <anonymous@.discussions.microsoft.com> wrote in message
news:38841121-069F-487F-A2C5-082ACA97A93B@.microsoft.com...
> Is there any expert in designing federated database ? I need a reference
in designing a federated database. Also a comparison - Federated database
VS single database server. I need a information in decided what solution i
should go for.
>
> Best regards,
> Tawana|||Why are you considering federated DBs? What are you
trying to achieve? Then we may be able to help you better.
>--Original Message--
>Is there any expert in designing federated database ? I
need a reference in designing a federated database. Also
a comparison - Federated database VS single database
server. I need a information in decided what solution i
should go for.
>
>Best regards,
>Tawana
>.
>|||Using a federation of servers comes with its own set of problems... MS
recommends ONLY using a federation when you have already scaled-up, meaning
you have bought the biggest, baddest, SMP box, and that box isn;t big
enough...
Make sure you have exhausted the alternatives before jumping into
federations..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"tawana" <anonymous@.discussions.microsoft.com> wrote in message
news:38841121-069F-487F-A2C5-082ACA97A93B@.microsoft.com...
> Is there any expert in designing federated database ? I need a reference
in designing a federated database. Also a comparison - Federated database
VS single database server. I need a information in decided what solution i
should go for.
>
> Best regards,
> Tawanasql