Check the following article:

http://social.technet.microsoft.com/Forums/sqlserver/en-US/3fdf1afb-7171-427c-a01c-2f29caaf3d00/how-to-fix-there-is-insufficient-system-memory-in-resource-pool-internal-to-run-this-query?forum=sqldatabaseengine

Also ask system admin to check if any issue with VMWare and check physical memory allocated to the server in VMWare correctly.

HTH

This is thumb rule or nature of law if in IT DBA'S paid more people will attact to that job and salary will nutralize. This is purle game of Demand...

No, SSMS open won't create any locking/blocking but I guess as you have mention that you opened SSMS and executed a few queries and if it ran for longer duration...

No body can do any operation on database which is in norecovery mode i.e. restoring. While when database is in standby mode it is available to people to read the...

It you are talking abou the job you can schedule it to run daily every 10 second between 23:00 to 3:00 hrs. However it won't be possible to set it...

Do you mean this:

INSERT INTO Table2 (Col1, Col2, Col3)

SELECT Col1, Col2, Col3 FROM Table1

Visit following link:

http://www.slideshare.net/PhilYoung4/hadoop-demo-ppt-17211338

Are you able to access from other server?

What is the growth of the Database? 15 GB is not huge data and you are purging only 1 GB and that too Database will occupy when insert will happen....

Check following link:

http://msdn.microsoft.com/en-us/library/vstudio/8xx3tyca(v=vs.100).aspx

HTH

While configuring Data Collection it will create one database in which it will store the data collection. So definitely it will create some disk i/o however it depends on what...

What if you stop and re-run your query again?

It is very difficult to find out as same query on the prod take different time to execute as it depends on lot of factors like:

1. Any other application is...

I doubt.

What is MAXDOP setting on the server?