Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
juvethski
Starting Member
46 Posts |
 Posted - 2005-10-28 : 12:23:59
|
| i'm fine tuning my scripts so instead of 1 big script, i've broken it down to 4. my question is how do i execute this 4 script so it runs all at the same time (parallel) instead of sequential. here's an example:update table1set column1 = 'a'update table2set column1 = 'b'update table3set column1 = 'c'update table4set column1 = 'd'if u just run this from the sql analyzer, are these going to run in parallel? or should i create a stored procedure?thanks!!~~~~~~~~~~~~~~~~how's your data? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-10-28 : 12:32:14
|
| You can open 4 QA Windows arrange them and execute them, although they won't all kick off at the same time, or you can put the scripts in to 4 jobs and set them to kick off at the same time...you will just need to make sure you redirect out put to a file or a table so you can see the results...Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
juvethski
Starting Member
46 Posts |
Posted - 2005-10-28 : 16:14:20
|
| the job suggestions sounds like a good idea. any other suggestions?thanks!~~~~~~~~~~~~~~~~how's your data? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-31 : 01:04:52
|
| Why do you want to run them simultaneously?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
fine tuning: scripts running at the same time?