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
>

download SQL Server Accelerator for BI

hi
i need the partition aggregation utility for sql server 2000
i found the link at microsoft but the download seems to be moved
http://www.microsoft.com/sql/prodinf...i/default.mspx
any ideas where i can find that tool?
thanks
andreas
Hi
Did you check out the link on
http://support.microsoft.com/default...b;en-us;897350
John
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
> hi
> i need the partition aggregation utility for sql server 2000
> i found the link at microsoft but the download seems to be moved
> http://www.microsoft.com/sql/prodinf...i/default.mspx
> any ideas where i can find that tool?
> thanks
> andreas
>
|||yubdidu - yahoo
great, thanks a lot
andreas
"John Bell" schrieb:

> Hi
> Did you check out the link on
> http://support.microsoft.com/default...b;en-us;897350
> John
> "Andreas" <Andreas@.discussions.microsoft.com> wrote in message
> news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
>
>

download SQL Server Accelerator for BI

hi
i need the partition aggregation utility for sql server 2000
i found the link at microsoft but the download seems to be moved
http://www.microsoft.com/sql/prodinfo/previousversions/ssabi/default.mspx
any ideas where i can find that tool?
thanks
andreasHi
Did you check out the link on
http://support.microsoft.com/default.aspx?scid=kb;en-us;897350
John
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
> hi
> i need the partition aggregation utility for sql server 2000
> i found the link at microsoft but the download seems to be moved
> http://www.microsoft.com/sql/prodinfo/previousversions/ssabi/default.mspx
> any ideas where i can find that tool?
> thanks
> andreas
>|||yubdidu - yahoo
great, thanks a lot
andreas
"John Bell" schrieb:
> Hi
> Did you check out the link on
> http://support.microsoft.com/default.aspx?scid=kb;en-us;897350
> John
> "Andreas" <Andreas@.discussions.microsoft.com> wrote in message
> news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
> > hi
> >
> > i need the partition aggregation utility for sql server 2000
> > i found the link at microsoft but the download seems to be moved
> >
> > http://www.microsoft.com/sql/prodinfo/previousversions/ssabi/default.mspx
> >
> > any ideas where i can find that tool?
> >
> > thanks
> > andreas
> >
>
>

download SQL Server Accelerator for BI

hi
i need the partition aggregation utility for sql server 2000
i found the link at microsoft but the download seems to be moved
http://www.microsoft.com/sql/prodin...bi/default.mspx
any ideas where i can find that tool?
thanks
andreasHi
Did you check out the link on
http://support.microsoft.com/defaul...kb;en-us;897350
John
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
> hi
> i need the partition aggregation utility for sql server 2000
> i found the link at microsoft but the download seems to be moved
> http://www.microsoft.com/sql/prodin...bi/default.mspx
> any ideas where i can find that tool?
> thanks
> andreas
>|||yubdidu - yahoo
great, thanks a lot
andreas
"John Bell" schrieb:

> Hi
> Did you check out the link on
> http://support.microsoft.com/defaul...kb;en-us;897350
> John
> "Andreas" <Andreas@.discussions.microsoft.com> wrote in message
> news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
>
>sql