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
I think the difference in memory consumption would be negligible. If you are doing multiple queries, I say you are best to leave the connection so as to not incur the connection overhead.