I'd also review the code. It definitely sounds like you're processing
row-by-row instead of taking advantage of SQL Servers SET based
approach.
If you have to process row-by-row, and you use DTS, bear in mind that
the database connection will only process commands sequentially, so make
sure you have a separate connection for each ExecuteSQL task.
Thanks
Phillip Carter
Ph: +61 3 9235 1691
-----Original Message-----
From: Pollock Kirsty
[mailto:mssqldba-ezmlmshield-x10550609.[Email address protected]
Sent: Friday, 29 October 2004 12:35 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query
Thought it was something like that. The DTS solution already mentioned
is the only option that I can think of.
Although, if it were me, I'd be tempted to look at optimising the code
> -----Original Message-----
> From: Singh Kanwar
> [mailto:mssqldba-ezmlmshield-x34974712.[Email address protected]
> Sent: 28 October 2004 14:53
> To: LazyDBA Discussion
> Subject: RE: parallel execution of query
>
> My process takes a long time to run and needs to be run for every
> contract and can be run at the same time using diff query analyzer
> window at the same time, I was thinking of automating this within the
> same proc.
>
> Kanwar
>
> -----Original Message-----
> From: Pollock Kirsty
> [mailto:mssqldba-ezmlmshield-x16411753.[Email address protected]
> Sent: Thursday, October 28, 2004 7:31 AM
> To: LazyDBA Discussion
> Subject: RE: parallel execution of query
>
> What do you mean by this?
>
> Do you mean you want to execute 2 queries asynchronously from with the
> same sp?
>
> I curious as to why.
>
> Kirsty
>
> > -----Original Message-----
> > From: Singh Kanwar
> > [mailto:mssqldba-ezmlmshield-x10766619.[Email address protected]
> > Sent: 28 October 2004 05:19
> > To: LazyDBA Discussion
> > Subject: parallel execution of query
> >
> > Hi All,
> >
> > I need to run more than one query at the same time within
> same stored
> > proc.
> >
> > Thanks in advance
> >
> > Kanwar
> >
> >
> >
> ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST
> REPLY Website
> > : http://www.LazyDBA.com To unsubscribe:
> > http://www.lazydba.com/unsubscribe.html
> > For additional commands, e-mail: mssqldba-[Email address protected]
> >
> >
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website
> : http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website
> : http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
IMPORTANT DISCLAIMER - THIS MAY AFFECT YOUR LEGAL RIGHTS:
Because this document has been prepared without consideration of any
specific clients investment objectives, financial situation or needs,
a Bell Potter Securities Limited investment adviser should be
consulted before any investment decision is made.
While this document is based on the information from sources which
are considered reliable, Bell Potter Securities Limited, its directors,
employees and consultants do not represent, warrant or guarantee,
expressly or impliedly, that the information contained in this document
is complete or accurate.
Nor does Bell Potter Securities Limited accept any responsibility to
inform you of any matter that subsequently comes to its notice, which
may affect any of the information contained in this document.
This document is a private communication to clients and is not intended
for public circulation or for the use of any third party, without the
prior approval of Bell Potter Securities.
Disclosure of Interest: Bell Potter Securities Limited receives commission
from dealing in securities and its authorised representatives, or introducers
of business, may directly share in this commission. Bell Potter Securities
and its associates may hold shares in the companies recommended.
Bell Potter Securities Limited ABN 25 006 390 772 AFS Licence No. 243480
MS Sql Server LazyDBA home page