Hard to really help when you only provide snippets of code.  In the last, why are you only inserting the data for a single id determined by the value of...

Any triggers on the table that are fired by an update statement?

I'm not really seeing what you are trying to accomplish.  What you are asking doesn't match the title of your post which is a count of products sold per minute,...

Again, we are just shooting in the dark.  Without the DDL for the tables and the view we really can't provide better answers.

Is this an internally used application or one that is internet facing where anyone can access it?  From your question it seems like an internal access only application.  You may...

No, the ANSI-92 style joins aren't faster than the ANSI-89 style.  What it does is help separate the joins that create the full result set from the filter conditions in...

Had an awesome day yesterday.  Just waiting for the team to implode, bye weeks not included.

If the code is dynamically built, yes,.