Hi All, I have a script which is working on multiple tables sequentially. All the DML's are mutually exclusive. My machine has multiple CPUs. Can i configure my SQL Server to run them parallely? If yes, how can i do it? What are the pros and cons of doing it in parallel? Any help/link/advice/experience on it is welcome. Regards, amitm79
Hi ya, you'd have to break up your script into multiple scripts and run all of them at the same time. A single script or proc will only have a single execution thread (although an individual statement within a script may use multiple CPUs to acomplish that statement) Cheers Twan
Hi Twan, I have twelve tables to update. Maintaining 12 separate scripts and executing them at the same time can be an overhead. I will see if i can come up with anything better else i will definitely try this out. Regards, amitm79
