Based on my reading of Netezza syntax online:

IF DATE_PART('DOW',CURRENT_DATE) IN ('3','6') THEN

statement

[statement] ...

END IF;

The two UPDATEs are already executed in separate transactions.  Since you don't have an explicit BEGIN TRANSACTION, every statement will be treated as a separate transaction by default.

Since the subquery...

You can add SET ARITHABORT ON to the trigger, but it may not help, because the error may be raised when the trigger is compiled the first time.

I don't understand...

You can use SET ARITHABORT and other SET statements within the trigger itself.  Those settings will be discarded when the trigger ends, so you can't do any harm to outside...

One should always try to avoid a function on a table column being used for lookup.  Therefore, for the last JOIN, do this instead:

  LEFT JOIN...

You don't really need to join, an EXISTS check will do fine.  The optimizer may rewrite it that way anyway, but it doesn't hurt to code it that way yourself:

You could also add a new filegroup and move the large tables into the new filegroup.  Then shrink the original file.  The big disadvantage, of course, is that you now...

Try:

EXEC sys.sp_depends 'BotCBO.vwClovekNameStrings_PrZk'

I've never been able to find a way to do this.  I ended up using CONTEXT_INFO() [*] or sp_set_session_context to pass the database_id to the called proc. [*] With provisions...

The easiest way to verify it is to look at the query plan.  You should be able to see that SQL is not actually pulling all the columns from that...

The column names will make no difference in a NOT EXISTS.  It's customary to use SELECT * or SELECT 1 in a NOT EXISTS query.

I'm not aware of any such tool.  If there were one, it would be rather expensive, I'm sure.

Tuning code for performance requires human skills (hallelujah!, since that's one of the...

If the OP runs the query I...

Is this the right way to calculate the size of logical reads?

Yes.

Should the size of logical reads be used to measure the performance or the number of logical reads provided...

You can't remove tempdb files while SQL is running.  Those are in effect system files.  When you recycle the SQL Server instance, your changes will be put into effect then.