DPV's

Is there any other way to do load-balancing other than SQL Server 2000's
Distributed partition Views? I am aware that 2005 has done something like
Distributed Tables, but that is, for my purposes, the same thing.
What I do not want to do is try to guess what gets accessed in what fashion
and try and place tables on various nodes of the cluster.\
Thanks,
jay2005's table partitioning cannot be distributed across servers. DPVs are
still the way to do that in 2005.
By the way, this isn't really "load balancing"--it's more along the lines of
scale out. For more traditional load balancing you might take a look at SQL
Server 2005's peer-to-peer replication technology (although I've heard very
mixed reviews on its effectiveness).
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Jay" <nospam@.nospam.org> wrote in message
news:OtIO7jo6HHA.5316@.TK2MSFTNGP04.phx.gbl...
> Is there any other way to do load-balancing other than SQL Server 2000's
> Distributed partition Views? I am aware that 2005 has done something like
> Distributed Tables, but that is, for my purposes, the same thing.
> What I do not want to do is try to guess what gets accessed in what
> fashion and try and place tables on various nodes of the cluster.\
> Thanks,
> jay
>