You have implicit conversions going on on your process_instance column. Your passing in an int column into a decimal column so SQL is having to convert the int to...

The optimiser is detailing a missing index, have you tried creating that index to see what performance improvement it is going to give you?

Can you also save the plan as...

Please can you post the table definitions and indexes of all tables being used in the query along with the execution plan for the query.

Yes, create a trigger on the "users" table for insert, so when a row is inserted then it sends a mail via sp_send_dbmail

If you need to create the index, you can either drop the procedure and ensure you have a backup to hand to recreate it. That will prevent anyone running...

There isn't a 64bit version of the Jet driver, you will need to run the package in 32bit mode.

http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspx

You would need to put a trace on your database for a considerable amount of time to gather what queries are run against it, then you will have a rough...

Unless your tracing all your queries you wont know about deletes, for drops if your quick enough you could look inside the default trace, but that gets overwritten quite quickly...

Just like you would any other trace.

Put a filter on the logon column for the logon in question

Does this do what you need?

SELECT DISTINCT TOP (100) PERCENT Date

FROM dbo.RMMarketPrice

WHERE Date BETWEEN dateadd(mm, datediff(mm, 0, @date),...

Just return null? No other data needs to be returned?

What is the expected outcome when it is the 1st of the month?

msdb.dbo.backupmediafamily contains the list of .bak / .trn files that have been created.

Check out Ola's scripts, link in my signature. Might seem daunting at first as its looks complex, but Ola does provide examples on how to use his maintenance tools.

I'd put a caveat on step 5 as it depends on your backup routines. If your doing daily full's then doing a diff wont help if you have waited...