The earlier you start, the sooner it'll be done

I...

Use LEFT, SUBSTRING and RIGHT along with CHARINDEX to locate the :. Break it into the hours, minutes and seconds, then convert each fragment to int and multiple by 60...

The TIME data type stores a time of day, not a time interval. Since a day has only 24 hours, that's the max that TIME can store (well, 23:59:59.9999...).

Time intervals...

To start, there's no indication the slow IOs are caused by autogrow operations, so changing your autogrow settings is probably not indicated at this point.

For your disks to be taking...

??

If it's a parameter, then it's passed to the batch/procedure from the app, so you would just reference the parameter name, rather than the hardcoded value that I put...

That's not T-SQL.

It is MDX? If it is, you'll need to look up the MDX date manipulation functions, they're not going to be the same as the T-SQL ones.

Yes, shrinking will reduce the size of the file. Will making the file smaller help with an error that's saying that the file need to be larger than it currently...

IF (SELECT p.ActivityCode FROM mission m LEFT OUTER JOIN product p ON p.extproductid = m.extproductid WHERE m.missionid = 12344) = 1

BEGIN

-- query to be selectively run goes here

END

If it's full (no free space, too small for current activity), why do you think that shrinking (removing free space, making file smaller) is the solution?

Is the column in the mission table or product? Is it just called "trigger"?

If it's in Product, there's a chance it could be NULL due to the outer join. If...

Ok, so what then, do you want to run the query and return an empty resultset? Not run the query at all?

And ditch those NOLOCK hints!

Still too vague.

What happens if there are multiple rows with trigger = 1 and multiple rows with trigger = 0?

When should the print not happen? When all rows have trigger...

I meant the whole batch of code, not a single select.

Firstly, ditch the NOLOCK hints, they're not go-faster switches, they're essentially WITH (RETURNPOTENTIALLYINCORRECTDATA) hints. If you don't mind the results...

https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

You can't, so make sure that all testing has been done before the upgrade day. And keep...