try scripting the jobs with various options , it will use some System procedures to create, schedule , enable etc.

if you can manage well these you can manage it through...

Can't you avoid the sub queries used these many times?

try inserting the subquery data to temp table and update and see how query performs.

as suggested above plan is best to...

try public permission for the database and grant update on table

http://technet.microsoft.com/en-us/library/ms188371.aspx

one more thing are you doing it daily? and what timings? try online reindexing

I think you are missing something can u have the parameters printed in a textbox and see whether it is as per you requirement or not.

Query slowness is due to serveral reasons

poor Statistics or index or disk or network need to have run trace and identify .

for interview questions you have get through experience...

But why not they check OS Memory before accepting it?

We have only 2005 test server for us , so i tried on strange it is accepting the value.

OH great , i am out of mind , this didnt strike great thought

Grant already you informed that it is not the best solution, my question is what if agent is down.

we definetely need a service out of SQL to monitor these. hopw...

Take application development team help and alert in email.

what is that some calculation and is that log grows after this or during this ?

Why?

Is this running with SORT_IN_TEMPDB ON?

But then over a night the size jump up to 42...

mJai (8/26/2013)

---

Thanks Durai! My thoughts were like this:

- shutdown the db

- move the files from this disk/drive(X) to another temporary disk/drive(Z)

- perform whatever maintenance to this disk drive X such...