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 |
|
Norwich
Posting Yak Master
158 Posts |
 Posted - 2006-02-16 : 09:22:11
|
| HiDoes anybody have an efficient way of using MaxDOP in a cursor?RegardsNThe revolution won't be televised! |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-02-17 : 00:08:39
|
| Huh? Maxdop has nothing to do with a cursor. |
 |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-02-17 : 03:43:42
|
| MaxDop Controls\Limits the number of processors to use in a parallel plan execution with the default value being the number of processors. My question is a rather simple one. Cursors usual take forever to process by design (row based instead of set based).I want to find out how I can limit the DOP in a cursor so that I don't hog the resources on the server.RegardsNThe revolution won't be televised! |
|
|
|
|
|
|
MaxDOP