Viewing 5 posts - 1 through 6 (of 6 total)
Wow thanks a lot for the revised script - I will test this with live data but the performance increase is amazing on test :-):-)
October 7, 2012 at 12:33 pm
whist experimenting with the query noticed that by removing the TOP1 the query suddenly started running in parallel mode which was A LOT faster. Still needed the TOP1 though but...
October 7, 2012 at 6:15 am
1. I have re-build all the indexes but that has not made a difference unfortunately
2. is there a way to post the graphic of the execution plan graphically - I...
October 6, 2012 at 6:59 pm
Have attached the execution plan - thank you so much for taking the time to look into this - it is driving me nuts at the moment....;-);-);-)
October 6, 2012 at 5:57 pm
Viewing 5 posts - 1 through 6 (of 6 total)