I'm a newbie to SQL sever.  I have questions about "Scale Up  and Scale out"
in SQL Sever. 

Can I use Blade Server as a method to scale up SQL Server 2000?  Basically,
can I keep adding more blades when database keeps growing or more demanding?

About scale out, how do I partition tables across the nodes?  Is it
automatically process or I need to manually partition them?  Will l see them
as one big table? 

Thanks,
SP

You can use multiple servers via Distributed Partitioned Views (DPV's).
However, re-partitioning is a manual process.  Your app will see the DPV as
a single "table".

That said, most well-designed apps don't need DPV's.  You'd need them only
when dealing with huge tables.

I'm a newbie to SQL sever.  I have questions about "Scale Up  and Scale out"
in SQL Sever.

Can I use Blade Server as a method to scale up SQL Server 2000?  Basically,
can I keep adding more blades when database keeps growing or more demanding?

About scale out, how do I partition tables across the nodes?  Is it
automatically process or I need to manually partition them?  Will l see them
as one big table?

Thanks,
SP

Reclaim space back
Quick question about rowguid column
This is probably a simple question, but...
AND and One to many relationships
SA Login