These procs are used by our web app; this is standard release procedure used for quite some time, but it slowness is becoming a problem because I can't limit access...

Well, that's how script was generated. I could see ALTER being faster than DROP/CREATE... not sure by how much though, will have to test.

Yes, it might... That's why I said running it with 25 threads using MultiScript does make it faster, but not fast enough; and having more than one instance of MultiScript...

Thank you. Yes, we have our own tool, and we can deploy to multiple servers at once. But the real issue is the time it takes to run the drop/create...

I watched these webcasts, they are truly deep stuff. Ramesh's style may be a bit unusual, and the pace is quite high, but examples he provided, and level of detail...