"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23CZz$cW5HHA.3716@TK2MSFTNGP03.phx.gbl...
> Yes, it looks like the technology you are looking for is called
> distributed partitioned views. There is some coding you will have to do to
> implement this.
>
> --
> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roy Goldhammer" <roy@hotmail.com> wrote in message
> news:%23iBJJYV5HHA.5984@TK2MSFTNGP04.phx.gbl...
>> Hello there
>>
>> For a knowlage i have i can't install sql server on windows NLB
>> clustering.
>>
>> IF that so i have some idea how to improve performance using replication:
>>
>> create 3 or more subscibers of my database for pooling data.
>> Create "Manual" technology that use more then one server for getting
>> data:
>>
>> for example: if i have sub1, sub2, sub3
>> User1 do select, it will be made from sub1.
>> User2 do the same select, it will be made from sub2 ect...
>>
>> If user1 do select from more then one table it will be done like this:
>> select ...
>> from sub1.db.dbo.table1
>> JOIN sub2.db.dbo.table2
>> JOIN sub3.db.dbo.table3
>>
>> This is looks very hard to program such thing like this. But it will make
>> the work match faster.
>>
>> If i need to do that will it be better to do it on sql server, or in .net
>> code?
>>
>> Does someone have seen software like this before?
>>
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:uYhz1ZY5HHA.980@TK2MSFTNGP06.phx.gbl...
> Roy,
> you could mimic NLB a little by distributing the data to the 3 subscribers
> as you mention. Each one would be set up as an updatable subscriber so the
> load would be spread across the subscribers: different clients would be
> pointed at different subscribers.
> Paul Ibison
>

"Roy Goldhammer" <roy@hotmail.com> wrote in message
news:%23iBJJYV5HHA.5984@TK2MSFTNGP04.phx.gbl...
> Hello there
>
> For a knowlage i have i can't install sql server on windows NLB
> clustering.
>
> IF that so i have some idea how to improve performance using replication:
>
> create 3 or more subscibers of my database for pooling data.
> Create "Manual" technology that use more then one server for getting data:
>
> for example: if i have sub1, sub2, sub3
> User1 do select, it will be made from sub1.
> User2 do the same select, it will be made from sub2 ect...
>
> If user1 do select from more then one table it will be done like this:
> select ...
> from sub1.db.dbo.table1
> JOIN sub2.db.dbo.table2
> JOIN sub3.db.dbo.table3
>
> This is looks very hard to program such thing like this. But it will make
> the work match faster.
>
> If i need to do that will it be better to do it on sql server, or in .net
> code?
>
> Does someone have seen software like this before?
>