It sounds like you are missing the boot.ini parameters that ALZDBA has mentioned.  Also, as ALZDBA has said, you want to leave memory for the OS.  I recommend 1...

The orginal post suggests that there are 2000 specific rows that need deleted. 

You say that you have the OriginalNo values for the 2000 rows you want to delete.  Where do you have these values?  Please reply and include your table DDL.

Are there clustered indexes on these small tables?  Can you post the SHOWCONTIG results for one of the tables in question?  According to Microsoft, you should not be concerned with...

This is a great example of how to use a numbers table in combination with a table valued split function.  Do a search on SSC for split or number table...

I think what he may be asking is which how to know which method to use.  Is this correct? 

If this is in a stored procedure, you always want to...

Well, if no new indexes are allowed then you don't have to worry about performance because you'll be able to guarantee that it will become poor as the table...

Keep in mind Tony that the amount of time a query takes is not solely dependant on that query alone; rather, on the cumulative load that all concurrent queries are...

I'd have to agree that 4-6 hours a day is a bit much for your everyday monitoring.  I don't have 4-6 hours per day to spend on any one...

It looks like this is a duplicate post to your other thread here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=361181

For the short term, I would suggest making changes to your maintenance plan so that you are...

FYI....

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=362112&post=true

What error message are you getting at the time of failure?

MSDB..SysJobs can tell you the last modified date of the job, but not who modified it.  I would suggest revoking permissions from the helpdesk staff,  or anyone for that matter,...

You must specify the column names as the error message suggests.

I'm afraid we are going to need more information in order to help you.  Can you describe what it is you're trying to do and post any code you have...