parallelism sql 2000

Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
BertoliYou don't need to have partitioned tables to use parallelism. All you need
are multiple CPU's. Parallelism is the striping of a query across multiple
CPU's. In many cases, this speed up the query. In a minority of cases, it
slows down the query. However, you can turn off parallelism for that query
by using OPTION (MAXDOP 1).
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
Bertoli|||SQL Server will parallelize queries as it is able (if you allow it to do
so). You do NOT need to create partitioned tables to use this feature.
Keith Kratochvil
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
> it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
> yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||tks guys
Bertoli
"Bertoli" <bertoli@.bertoli.com.br> escreveu na mensagem
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||You can get more info from BOL by searching for
* Max degree of parallelism
Thanks
Ajay Rengunthwar

parallelism sql 2000

Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
BertoliYou don't need to have partitioned tables to use parallelism. All you need
are multiple CPU's. Parallelism is the striping of a query across multiple
CPU's. In many cases, this speed up the query. In a minority of cases, it
slows down the query. However, you can turn off parallelism for that query
by using OPTION (MAXDOP 1).
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
Bertoli|||SQL Server will parallelize queries as it is able (if you allow it to do
so). You do NOT need to create partitioned tables to use this feature.
--
Keith Kratochvil
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
> it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
> yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||tks guys
Bertoli
"Bertoli" <bertoli@.bertoli.com.br> escreveu na mensagem
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||You can get more info from BOL by searching for
* Max degree of parallelism
Thanks
Ajay Rengunthwar

Page number doubt in RS2000

Hi,
I have created a report which has a Table of Contents and two other sections say Sec1 and Sec2. Sec1 and Sec2 have tables which are populated from the database. The page numbers of Sec1 and Sec2 are not known at design time. In the Table of Contents, I need to show the page numbers where Sec1 and Sec2 start. How can this be accomplished?

Regards,
Asim.Were you able to find a solution? I am also looking to solve this issue for my reports.