Slow running query

Question

Slow running query

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

glad to hear you are making some progress.

kind regards

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Jeff Moden SSC Guru Points: 1004499 More actions · Answer 2

Thank both of you for your thoughtful feedback and for the experiments you've done with the data.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

eseosaoregie SSCertifiable Points: 6889 More actions · Answer 3

Hi guys,

Just to let you know that running the script within SSIS as mentioned above got the query time down to 45 secs.

thanks

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 4

eseosaoregie (4/16/2013)
Hi guys,
Just to let you know that running the script within SSIS as mentioned above got the query time down to 45 secs.
thanks

I make that 32x quicker .....pretty impressive :Wow:

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day