Load Balancing

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila
"Leila" <Leilas@.hotpop.com> wrote in message
news:O9er3Ei1EHA.3540@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need a solution to perform load balancing on my OLTP database, for
> example
> between two servers.
> Any help would be greatly appreciated,
> Leila
>
SQL Server does not do load balancing automatically.
You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.
Check out Partitioned Data in the BOL.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Load Balancing

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila
"Leila" <Leilas@.hotpop.com> wrote in message
news:O9er3Ei1EHA.3540@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need a solution to perform load balancing on my OLTP database, for
> example
> between two servers.
> Any help would be greatly appreciated,
> Leila
>
SQL Server does not do load balancing automatically.
You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.
Check out Partitioned Data in the BOL.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Load Balancing

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila"Leila" <Leilas@.hotpop.com> wrote in message
news:O9er3Ei1EHA.3540@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need a solution to perform load balancing on my OLTP database, for
> example
> between two servers.
> Any help would be greatly appreciated,
> Leila
>
SQL Server does not do load balancing automatically.
You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.
Check out Partitioned Data in the BOL.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Load Balancing

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila"Leila" <Leilas@.hotpop.com> wrote in message
news:O9er3Ei1EHA.3540@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need a solution to perform load balancing on my OLTP database, for
> example
> between two servers.
> Any help would be greatly appreciated,
> Leila
>
SQL Server does not do load balancing automatically.
You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.
Check out Partitioned Data in the BOL.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

List in list?

Hello everybody,

I am new to the whole reporting World and I was wondering if their is a solution for my problem. I searched for one and a half hour and I am getting desperate.

I need to repeat a report. So I thought: I can use a list for that. But when I placed all my objects in that list and linked it to a data source it gives an error at every object. I had this problem before and I made a work around so I did not solve it. I need a list in a list or a matrix in a list. I get the following errors:

Error 1 [rsDataRegionInDetailList] The list ‘list3’ is in a list that has no group expressions defined for it. To use a data region in a list, the list must have group expressions. c:\projecten\citrix\test\citrixusagedb\report\CitrixUsage.rdl 0 0

Error 2 [rsFieldReference] The Value expression for the textbox ‘textbox16’ refers to the field ‘USERNAME’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. c:\projecten\citrix\test\citrixusagedb\report\CitrixUsage.rdl 0 0

I hope you can help me, thanks in advance!

Yours,

Stef

I found the soluition!

I had to use a subreport