I'm having problems with consumption of the CPU and the memory.
What of these options would help me to consume less?


Option #1
Connect to sql server, execute the sql command and disconnect once it is done. And do again for each command.

Option #2
Connect to sql server, execute all the sql commands and disconnect when script dies.


More ideas will be very appreciated.

Thank you