Thought this was a trick question based on the column name. Column1 in the table vs Col1 in the SQL.

Thank you!! That's what I was looking for. This is really an inconvenience that SQL Server doesn't handle this, it is really killing performance in our system.

I agree this was very poorly worded. Even if SQL were to set this to simple on a re-boot, it doesn't specify whether or not this maintenance plan has a...

Since this is an update there essentially no difference because the update will still need to acquire an exclusive lock in order to perform the update. Thus, if another transaction has locks...

That's it! Thanks so much!