Your main problem is that you are updating too many rows at a time. SQL Server creates an implicit transaction for each separate query (if...
Separate names with a comma.
