I suspect there though dbmail has not been configured somewhere your job is trying to generate mail report. Check your maintenance plan or job for any such options. Also check...

Each transaction will be loged into the transaction log for simple, bulk-loged or full recovery.

If simple recovery is set than transaction log truncated after each transaction commits and hence...

If SQL Server configuration is fine execute following commnad to find memory related details.

select * from sys.dm_os_performance_counters where object_name like '%Memory Manager%'

HTH

Good Question, Thank you!!!

Yes, me too worng....

The correct answer is none. As though resource database is readonly we can move it along with master.

http://msdn.microsoft.com/en-us/library/ms345408.aspx

Actually it depends, what exactly your customers requirement is.....

because from budget to latency and dataloss it depends.

But I guess budget is low and latency will be fine from your description....

If I guess correctly you are facing this problem after perfroming the BCP. I suggest you rebuild the indexes of respective table after doing BCP.

HTH

If the database is in use you will not be able to put it offline.

For that you do have two option:

1. Kill the connection to the respective database

2. In addition...

From cluster can you try to access the shared folder where you are copying the file for LS? Use same login which is set up for LS.

check Alter login...

http://msdn.microsoft.com/en-us/library/ms189828.aspx

This will help you. You just need to create small programme to do it automatically.

HTH

Also make a note that table scan is not always BAD!! As mention by Gilamonster SQL Server is smart enough to select best execution plan for your query :-).

Aaha... I got the article finally...

http://www.sqlskills.com/BLOGS/PAUL/post/Benchmarking-do-multiple-data-files-make-a-difference.aspx

Hope this will hlep you.

Restructuring File & File group will surely help you in maintenance as mention in the above posts also you will be benefited for the performance as you will have multiple...

pl. be more specific? what exactly would you like to do?

Here your object is to run the query online. But I am not sure how it will helpful? As your database structure is different.

Now to overcome your issue I...