Used to be a really common way of doing multiple tasks in the "Good Old Day" before Microsoft gave us things like sp_MSForEachTable and the like...:-P

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

covers most of your requirements

use mountpoints, then mount the 1st drive as f: and the next drive as F:\SQLData, next f:\SQLLogs etc for instance1 then do the same for instance2 but make that G:\.

4...

create a select statement for the funding table using a rownumber field so each project has a number based on the Project ID.

Then do a straight select statement joining...

Have you tried optimising the queries to improve performance, and what Isolation level are you using as this can have a dramatic impact if your for example trying to report...

Have you tried applying a server side trace to see what is happening with the Database during the backup period, and maybe running perfmon counters to check throughput of the...

Server

Sounds like you have design issues there with mixing of datatypes.

Could try using an ISNUMERIC function to see if the data is numeric then rtrim and some pattern matching to...

If the issue is specific to these backups then check the mountpoint, and LUN setup you are writing to, could be you have a disk within the LUN (or if...

So are you saying the log file is 300Gb and full being caused by an open transaction on the server use DBCC OPENTRAN to work out if the log is...

You can try the usual method of SP_WHO2 and SP_Lock if you are around and able to query while the locking is happening. Otherwise you can try something like the...

Have you tried outputting the value produced to a table or something to have a look at the results. This might give a greater insight into why the values are...

Also worth noting its not just Dirty reads you could potentially be talking about duplicate data reads if your IAM pages split out, or missing data if the pages shrink...