I agree. Kanwar has never posted exactly what he's doing to see if
anyone can reframe it in a set based solution.

Kanwar - we may be able to help you if you post the steps that you are
doing for each contract and may even the code that you're currently
performing.

Brian Freeman
Carnegie Technologies/Bluewave Computing
(770) 916-0595 ext. 415
www.carnegie.com
www.bluewave-computing.com



-----Original Message-----
From: Pollock Kirsty
[mailto:mssqldba-ezmlmshield-x56391755.[Email address protected]
Sent: Friday, October 29, 2004 11:03 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query


As I understand it, Kanwar's problem is perfomance, so he wants to run
individual updates/inserts in parallel - each one takes a long time.
This is why several of us are urging a look at basic strategy, as this
is often where huge savings can be made.

I say this very carefully, but ... *most* cursor-based solutions are
slower than the equivalent set-based solutions and in some cases by very
large factors. It is very rare that a database programming task cannot
be solved using set-based operations - at least such has been my
experience, and I've had done my fair share of optimisation.

I'm NOT looking to get into an OT discussion on that topic, just
mentioning it, since performance seems to be the major issue with the
problem as stated.

> -----Original Message-----
> From: Mat.Elkington
> [mailto:mssqldba-ezmlmshield-x1006649.[Email address protected]
> Sent: 29 October 2004 15:08
> To: LazyDBA Discussion
> Subject: RE: parallel execution of query
>
>
> So again, why not use a cursor...?
>
> -----Original Message-----
> From: Pollock Kirsty [mailto:mssqldba-ezmlmshield-x76470629.[Email
> address protected]
> Sent: 29 October 2004 14:56
> To: LazyDBA Discussion
> Subject: RE: parallel execution of query
>
>
> I still don't see why that mandates doing one contract at a
> time as opposed to a set-based operation.
>
> > -----Original Message-----
> > From: Singh Kanwar [mailto:mssqldba-ezmlmshield-x33555071.[Email
> > address protected]
> > Sent: 29 October 2004 14:27
> > To: LazyDBA Discussion
> > Subject: RE: parallel execution of query
> >
> > i do not know all the contractIDs in the advance, it has to
> be picked
> > up from other table at the time of execution, because the
> contractids
> > keep changing. because of nature of work, DTS is not feasable.
> >
> > Thanks
> >
> > KP
>
>
>
> ---------------------------------------------------------------------
> 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]
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity
> to whom they are addressed. If you have received this email
> in error please notify the system manager.
> This footnote also confirms that this email message has been
> swept for the presence of computer viruses but this in no
> way indicates that the message is virus free.
> **********************************************************************
>
>
>
> ---------------------------------------------------------------------
> 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]


MS Sql Server LazyDBA home page