Shadab Shah (1/10/2014)
Just thought of giving a Update.
The query is running with in the stipulated time.
Nothing has changed over a period of time no server settings have changed not even query
Has anybody faced this Issue. This is really puzzlling . What could be the root cause
I have, indeed, run into such a thing. When it occurs, it's normally either due to a conflict with other things OR it's because the UPDATE is (what I call) an "illegal update". There is a particular form of the UPDATE statement that usually works but, in fact, is not mentioned anywhere in Books Online (which is why I call it "illegal").
Please post the UPDATE statement that you were having troubles with so we can have a look.
is pronounced ree-bar and is a Modenism for R
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs